A canvas app loads data from a SQL Server table into a collection. The collection is used to populate a gallery. The app must allow the user to edit the data in the gallery and then save changes back to SQL Server. What is the best approach?

Use a global variable to store the edited records and then submit them

Use the SQL Server table directly as the Items property of the gallery and use Patch to update the table

Use the collection as the Items property of the gallery and use Patch to update the collection, then use a button to submit changes to SQL Server

Use a context variable to store the edited records and then submit them

A canvas app has a screen that allows users to enter multiple line items. The app must validate that all line items have a quantity greater than zero before allowing submission. The validation should run when the user clicks 'Submit'. Which approach should you use?

Use a context variable to store the line items and check the variable's value on submit

Use a SharePoint list to store the line items and validate on the server

Use a global variable to store the line items and check the variable's value on submit

Use a collection to store the line items and use the Filter function to check for invalid quantities

Microsoft Certified:Power Platform Functional Consultant Associate

Domain 2Objective 2

Describe Canvas Apps PL-200 Practice Questions (Page 5)

Part of the Create apps by using Microsoft Power Apps domain, which accounts for 25–30% of the PL-200 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

7concepts

25–30%of the exam

Questions 21–25

21foundation · easy
Which Power Apps function is used to navigate from one screen to another in a canvas app?
Select an answer first
22expert · hard
A canvas app loads data from a SQL Server table into a collection. The collection is used to populate a gallery. The app must allow the user to edit the data in the gallery and then save changes back to SQL Server. What is the best approach?
Select an answer first
23expert · hard
A canvas app has a screen that allows users to enter multiple line items. The app must validate that all line items have a quantity greater than zero before allowing submission. The validation should run when the user clicks 'Submit'. Which approach should you use?
Select an answer first
24foundation · easy
Which function in Power Apps is used to check if a formula returns an error?
Select an answer first
25foundation · easy
In a canvas app, which component represents a single page or view that users interact with?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-200

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-200” is a trademark of its owner, used for identification only.

Describe Canvas Apps PL-200 Practice Questions (Page 5)

Questions 21–25

Which Power Apps function is used to navigate from one screen to another in a canvas app?

A canvas app loads data from a SQL Server table into a collection. The collection is used to populate a gallery. The app must allow the user to edit the data in the gallery and then save changes back to SQL Server. What is the best approach?

A canvas app has a screen that allows users to enter multiple line items. The app must validate that all line items have a quantity greater than zero before allowing submission. The validation should run when the user clicks 'Submit'. Which approach should you use?

Which function in Power Apps is used to check if a formula returns an error?

In a canvas app, which component represents a single page or view that users interact with?

Keep studying — Create apps by using Microsoft Power Apps