Microsoft Certified: Power Platform App Maker Associate Microsoft Certified: Power Platform App Maker Associate 5 — Questions and Answers
Question 1: What is the correct way to filter a gallery in a Power Apps canvas app to show only records where the Status column equals 'Active'?
- Set the gallery's Items property to Filter(DataSource, Status = "Active") (Correct answer)
- Use a search bar control only
- Set the gallery's Visible property to Status = "Active"
- Add a business rule on the data source
Correct answer: Set the gallery's Items property to Filter(DataSource, Status = "Active")
The Filter() function in the gallery's Items property evaluates a condition for each row and returns only matching records from the data source.
Question 2: In Microsoft Dataverse, which column type stores a reference to a record in another table?
- Lookup column (Correct answer)
- Choice column
- Text column
- File column
Correct answer: Lookup column
A Lookup column in Dataverse stores a pointer to a specific record in a related table, establishing a many-to-one relationship.
Question 3: Which Power Platform tool allows makers to analyze and improve business processes using process mining before building automation?
- Power Automate Process Mining (Correct answer)
- Power BI Dataflows
- Power Apps Ideas
- Copilot Studio
Correct answer: Power Automate Process Mining
Power Automate Process Mining analyzes event logs from existing systems to visualize actual process flows and identify bottlenecks before building automations.
Question 4: What is the maximum number of rows that the default Power Apps delegation-supported functions can retrieve from large data sources like Dataverse?
- Delegable queries retrieve all matching rows regardless of limit; non-delegable functions are capped at 500-2000 rows (Correct answer)
- Always exactly 100 rows
- Exactly 10,000 rows for all functions
- Unlimited for all functions
Correct answer: Delegable queries retrieve all matching rows regardless of limit; non-delegable functions are capped at 500-2000 rows
When using delegable functions (Filter, Sort) against Dataverse, the data source processes the query server-side and returns all matches; non-delegable operations only process up to the app's row limit (default 500, max 2000).
Question 5: In a Power Automate cloud flow, what is the difference between a 'condition' action and a 'switch' action?
- Condition handles true/false branching; Switch handles multiple discrete value branches (Correct answer)
- Condition handles multiple branches; Switch handles only two
- They are identical in functionality
- Switch only works with numeric values
Correct answer: Condition handles true/false branching; Switch handles multiple discrete value branches
A Condition action creates a binary true/false branch, while a Switch action evaluates a single value against multiple cases, making it cleaner for multi-option logic.
Question 6: Which Power Apps formula correctly displays today's date formatted as MM/DD/YYYY?
- Text(Today(), "mm/dd/yyyy") (Correct answer)
- Format(Now(), "MM/DD/YYYY")
- DateFormat(Today(), Short)
- ToString(Date.Now, "MM/DD/YYYY")
Correct answer: Text(Today(), "mm/dd/yyyy")
The Text() function formats a date value using a format string, and Today() returns the current date without time; 'mm/dd/yyyy' is the Power Apps format pattern for US date display.
Question 7: What is the purpose of a 'solution' in the Power Platform?
- A container that packages app components for transport between environments via ALM (Correct answer)
- A help documentation library
- A type of Power Automate flow
- A security role template
Correct answer: A container that packages app components for transport between environments via ALM
Solutions are containers that group Power Platform components (apps, flows, tables, etc.) to enable Application Lifecycle Management (ALM) by importing/exporting them between environments.
Microsoft Certified: Power Platform App Maker Associate Microsoft Certified: Power Platform App Maker Associate 5
What is the correct way to filter a gallery in a Power Apps canvas app to show only records where the Status column equals 'Active'?