Dummy’s Guide to expand query in Flow

Expand query really simplifies one’s Flows, but the syntax is a killer. I forget this after 10 minutes so a super brief primer.

Below, expanding the query to get the licenses attached to a system.

The key is to ensure the lookup table uses the navigation property table name, easily seen in the all fields view. That capital letter is vital !

Select any required fields or leave out to get all. To go deeper just add an embedded expand in the same way:

ltcit_License($select=ltcit_remaininglicenses,ltcit_licensesassigned;$expand=systemuser($select=fullname))

To use these values requires more fun:

outputs('Get_the_System_row_by_ID_incl_License')?['body/ltcit_License/ltcit_licensesassigned']

Get the body output from another field on that action, and add in the expanded entity and field required after body. This has to be done by the expression editor.

If you want to expand multiple relationships at once inside an expand query, simply separate with a comma, e.g.

ltcit_License($select=ltcit_remaininglicenses,ltcit_licensesassigned;$expand=systemuser($select=fullname),ltcit_otherEntity($select=name))