PL-400: Microsoft Power Platform DeveloperDemo

By Microsoft · Question Mode

QuestionQ123

Create and configure Power Apps

You are developing a canvas app that connects to Microsoft Dataverse. You add the Accounts table as a data source for the app and implement a gallery to display information from the Accounts table.

The Accounts table is saved and cached locally in a collection named collAccounts. The gallery data must always show accounts that have a name value. The gallery uses the following Power Fx formula:

Question Image

You deploy the app to production.

Users report that the app does not show the expected number of Account rows.

You need to fix the user issue.

How should you modify the Power Fx formula?

  • A Sort(Accounts, 'Account Name', SortOrder.Descending)
  • B Sort(collAccounts, 'Account Name', SortOrder.Descending)
  • C Filter(Sort(Accounts, 'Account Name', SortOrder.Descending), IsBlank('Account Name') = false)
  • D collAccounts
Explanation

A local collection can represent only the portion of Dataverse data retrieved into the app; ClearCollect is nondelegable and can therefore yield incomplete results. Applying the filter and sort directly to the Dataverse Accounts table lets Power Apps delegate those operations and retrieve gallery rows as needed. Dataverse supports delegation for Filter, text Sort, and IsBlank on text columns.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!