In the competitive field of Power Apps development, excelling in interviews is crucial for landing your dream job. To help you prepare effectively, CourseElevate has compiled a comprehensive list of the top Power Apps interview questions and expert answers. Whether you’re a seasoned pro or just starting your career in app development, these meticulously curated Power Apps interview questions and in-depth expert answers will equip you with the knowledge, skills, and confidence needed to impress potential employers.
(1) Explain the use of the “ResetForm” function in Power Apps.
The “ResetForm” function in Power Apps is used to clear the data and reset the state of the form control. When you’re working with forms in Power Apps, such as EditForms or NewForms, you can use this function to clear the fields and return them to their initial state. Additionally, you can customize the behaviour of “ResetForm” to suit your specific requirements.
Syntax:
ResetForm(FormName, Mode)
FormName: This is the name of the form control that you want to reset.
Mode (Optional): Specify the mode in which the form should be reset. It can take the following values:
Edit: This is the default mode, and it resets the form to its initial state as if it were just loaded. New: This resets the form to its initial state, but it also sets it to “New” mode, which is often used for creating new records.
(2) What are the available data sources for Canvas Apps?
Following are the available data sources for Canvas Apps.
Common Data Service (CDS)/ Data Verse: A secure data platform by Microsoft for organized and standardized data storage. Microsoft has renamed its name as DataVerse.
SharePoint: You can connect Canvas Apps to SharePoint lists and libraries to interact with documents, lists, and metadata.
Excel: You can use Excel tables and files stored in OneDrive or SharePoint as data sources for your apps.
SQL Server and Databases: Power app can be connected to on-premises or cloud-based databases like SQL Server, Azure SQL Database, MySQL, and others using connectors or custom connectors.
Dynamics 365: Canvas Apps can access data from Dynamics 365 Customer Engagement, such as customer records, leads, opportunities, and more.
Office 365 and Microsoft 365: Power can access data from Office 365 services like Outlook, Calendar, and OneDrive for Business, as well as Microsoft 365 services.
Azure Services: It can utilize various Azure services as data sources, including Azure Blob Storage, Azure Table Storage, and Azure Cosmos DB.
Custom APIs: Create your own data connections to external services using custom connectors.
Web Services: Power app can also connect to data on websites or online services using web addresses.
Power BI Data: Embed Power BI reports and dashboards in your Canvas Apps, making it possible to interact with Power BI data directly within your apps.
Custom Data Sources: Develop custom connectors using Power Platform connectors or Azure Logic Apps to connect to custom data sources.
(3) How do you filter data in a Gallery control?
To filter data in a Gallery control in Power Apps, you can use the Items property of the Gallery control. The Items property is a formula that returns a list of items to display in the Gallery control. You can use this formula to filter the data by using a condition.
The syntax for filtering data in a Gallery control is as follows:
Filter(DataSource, Condition)
Where:
- DataSource the Gallery control is connected to the DataSource, which serves as the underlying table.
- Condition is the filter condition for the data source
The condition can be any valid Power Apps formula. For example, the following example filters the data in the Gallery control to only show items where the Age column is greater than 21:
Filter(DataSource, Age > 21)