Top 10 #PowerApps Interview Questions and Answers

???Where do I store my data in?#PowerApps

1. SharePoint Online is suitable for simpler data designs and smaller data sizes.
2. Dataverse for Teams offers up to 2 GB of storage within Microsoft Teams, making it a good choice for smaller teams and projects.
3. When dealing with larger data sizes or heightened security requirements, consider migrating to Dataverse for more robust data storage and enhanced security features tailored to your environment.

????How does where I store my data impact what type of app I use?

1. If you're working with a #SharePoint data source, you can utilize the #Canvas app.
2. However, if your data source is #Dataverse or #SQLServer, premium connectors will be necessary.

??What type of other decisions go into what type of app do I build?

1. If your users are external, consider leveraging #Dataverse and #PowerPages for your solution.
2. Within #PowerApps, implement row-level security measures to ensure appropriate data access for your users.

?? I’m getting the wrong answers when I search my SharePoint list (it's missing rows). What could be cause that?

The primary factor to consider here is delegation. Power Apps heavily relies on the capabilities of the data source, and when dealing with data source limitations, such as those in SharePoint Online, delegation issues can arise due to factors like data size and bandwidth constraints.

It's worth noting that SharePoint isn't designed to function as a traditional database, which often leads to more frequent delegation warnings when used in conjunction with Power Apps.

For more Power Apps delegation videos, highly recommend?Reza Dorrani?playlist.

https://www.youtube.com/watch?v=gwiErbYtRdA&list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

??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.

?? What type of coding does one use in Power Apps?

Power Apps employs a language known as #PowerFX, and you can find references to the most frequently used functions in this language. These common #PowerApps functions share similarities with Excel functions, making them familiar and accessible to users familiar with spreadsheet software.

https://pragmaticworks.com/resources/cheat-sheets/power-apps-cheat-sheet-page/

For Power Pages, there is another language called?#Liquid?and?#JavaScript.

??What is?#Dataverse?

The primary objective of Dataverse is to make database development accessible to a wider audience. Dataverse operates as an SQL server in the background, allowing users to create tables using a web interface, without the need for coding experience.

??What are a few ways to send data to a data source?

Utilize forms to connect with your data source, select the desired fields, and make use of the "OnSelect" property. It's worth noting that while forms offer a straightforward approach, you can also employ Patch, which provides greater flexibility and capabilities, making it a more robust choice.

?? 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.

???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/