Click HereFilter Query, Expand Query in Power Automate flow – Get Collection of record from CDS Microsoft dynamics 365 – List Records using filter query Orderby Expand Query
Filter ($filter)
Order By ($orderby)
Top ($top)
Expand ($Expand)
Three: Expend ($Expand) in list records action to pull Related Entity and apply $select to specify Attribute of the related entity i.e
The $expand system query option specifies the related resources to be included in line with retrieved resources.
Some examples are :
$expand=primarycontactid($select=fullname)
$expand=primarycontactid$filter=emailaddress1 eq null)
$expand=customerid_account($select=name,address1_city)
$expand=customerid_contact($select=fullname,address1_city)
Example : Expand Contact entity, simple primary contact lookup i.e $expand=primarycontactid
Example: Expand Contact entity, simple primary contact lookup with filtering $expand=primarycontactid($filter=emailaddress1 eq null)
Some Other Examples
Example: expand a navigation property of an entity type
$expand=Category
Example: expand a navigation property of a Customer type
$expand=customerid_account($select=name,address1_city) $expand=customerid_contact($select=fullname,address1_city)
Example: Expend related Entity with a date equal to null
$expand=Primarycontactid($filter=SomeDate eq null)
