Use Expand Query to retrieve related Dataverse data in Power Automate
Diesen Beitrag auf Deutsch lesen
Configure Dataverse Get a Row by ID with Expand Query, then access related fields through a custom expression in later flow actions.
TL;DR
Power Automate's Dataverse Get a Row by ID action uses an OData-style Expand Query to return related table data. The guide shows primarycontactid($select=contactid,fullname), then accesses the expanded values with Body('Get_a_row_by_ID')?['primarycontactid']['FullName'] in subsequent actions.
Original by Griffin Lickfeldt, on Citizen Developer. Read the original
This is our own summary, not a republication or full translation.
Why it matters
- Makers: Add the related table navigation property to Expand Query and use $select when you need specific columns, such as contactid and fullname.
- Makers: Retrieve expanded values with a custom Body expression when they do not appear in the Dynamic Content panel, so later actions can use the related record data.
Frequently asked questions
How do I return related Dataverse columns with Power Automate Expand Query?
Use the Expand Query field in Dataverse Get a Row by ID to request related table data with an OData-style expression.
How can I limit fields returned by a Power Automate Dataverse lookup?
Add $select after the navigation property and list the required columns, such as contactid and fullname, for the related record.
How do I reference expanded Dataverse data in a later flow action?
Use a Body expression containing the action name, lookup schema name, and related column logical name to retrieve the expanded value.