Top 10 #PowerApps Interview Questions and Answers – Part
1. 📌 Where do I store my data in #PowerApps
Depends on the data source and security that you go for.
SharePoint Online for simpler data design and data size.
Next would be Dataverse for Teams with 2 GB for the Microsoft team.
Move to Dataverse for larger data size and security for your environment.
2. 📌How does where I store my data impact what type of app I use?
For the #SharePoint data source, the #Canvas app could be used.
If your data source is #Dataverse or #SQLServer, then premium connectors are required.
3. 📌What type of other decisions go into what type of app do I build?
It depends on your audience. If users are external, then use #Dataverse and #PowerPages.
Use row-level security within #PowerApps.
4. 📌 I’m getting the wrong answers when I search my SharePoint list (it's missing rows). What could be cause that?
The simple reason is delegation. Power Apps to give hard work to the data source and if the data source has limitations such as SharePoint Online in terms of megabytes and bandwidth.
SharePoint is not a database and therefore we get more delegation warnings for SharePoint Online.
For more Power Apps delegation videos, highly recommend Reza Dorrani playlist.
https://www.youtube.com/watch?v=gwiErbYtRdA&list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
5. 📌What else can I do with my apps?
700+ connectors could help in creating apps with #PowerAutomate or integrating with #PowerBI or using #PowerVirtualAgents. You can use #AIbuilder.
6. 📌 What type of coding does one use in Power Apps?
Power Apps officially use a language called #PowerFX and the most common functions can be referenced here. Common #PowerApps functions are like Excel.
https://pragmaticworks.com/resources/cheat-sheets/power-apps-cheat-sheet-page/
For Power Pages, there is another language called #Liquid and #JavaScript.
7. 📌What is #Dataverse?
The main goal for Dataverse is to democratize the ability to build out databases. Dataverse is an SQL server behind the scenes, and you can create tables with the web page. No coding experience is required.
8. 📌What are a few ways to send data to a data source?
Using Forms and hook into the data source. Select the fields and use the OnSelect property. Forms are a bit rigid, and we can use Patch which has more power.
9. 📌 What are some best practices for end-user experience for an app
It's personal preference, but you use something like Creator kit https://docs.microsoft.com/en-us/power-platform/guidance/creator-kit/overview
Provided best practices and it Fluent design theme editor, Code components, Component library etc.
You can build your own themes.
Users can submit forms and we can enforce required fields before we submit them to the data source.
10. 📌 What are some common user interface best practices?
a) Use the creator kit https://docs.microsoft.com/en-us/power-platform/guidance/creator-kit/overview
Create your own theme and export.
b) Use the Center of Excellence (CoE) toolkit.
https://docs.microsoft.com/en-us/power-platform/guidance/coe/starter-kit
c) Use the Component library. https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/component-library
d) PCF library. https://pcf.gallery/
