Quite often, we need to specify the attributes to select or the filter conditions on related entities in DataVerse connector in Microsoft Flow.
Expand Query is exactly where we can specify those. However, the Flow designer does not have the context awareness and showing you an easy to select list.
Furthermore, the expand query is case sensitive that it must match the relationship Schema as how it was entered in DataVerse upon creation. One may entered it with upper case or all lower cases, eg. new_Account.
Luckily, the FetchXMLBuilder tool in XrmToolbox comes with a very handy feature that can generate the query for us.
In the example below, my query sets to return name attribute, and filtering on name equals 'test'.
Click on View menu, then select OData 4.0 (WebAPI).
The OData query will be generated for you at the bottom of the screen.
You may then simply copy and paste the $expand query to the Expand Query of Microsoft Flow designer.
Thats it for now.
Comments