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?