Using Expand Query Does Not Show in Dynamic Content

[bumblingcoder]

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

[ManishJain]

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'].

Thanks