Question
You create a Power Automate flow that retrieves data from the Microsoft Dataverse Account table.
The flow uses only a subset of Account table data.
You need to retrieve the required data.
How should you configure the Dataverse List rows action? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Full name of the primary contact: fullname is a column of the related contact, not of the account, so it is retrieved through the primarycontactid navigation property in Expand Query using the OData form primarycontactid($select=fullname). Select columns only accepts columns of the Account table itself, and the /primarycontactid?$select= form is not valid expand syntax. Account with the highest credit limit: sort the rows by creditlimit in descending order and set Row count to 1 so only the top row is returned. Sorting ascending would return the lowest credit limit, and Expand Query only works on related tables, not to limit the primary table's rows.
