Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Using Expand Query Does Not Show in Dynamic Content

I am building a flow that is scheduled nightly to get all the open appointments and send one email to the owners that has the list of appointments they have open

I am using the expand query to get the data, but while the flow succeeds and in the output, I can see the internal email address field and data but in the Create HTML, I cannot select the field in the dynamic content.

This is just a stub, so ignore my filter.  The issue is with the email address not pulling.  I also went after the regarding opportunity data and that is not pulling into the dynamic content page.  I used XRMToolbox to generate the expand query text.


Any ideas on how to get these fields into my dynamic content?

Here is my test flow


Solution Sage
Solution Sage

Hi @bumblingcoder ,


You will not see those in expand query by default. Rather while you are doing mapping you can do like this:

owningmail ==> item()?['owninguser_appointment']?['internalemailaddress'].



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,178)