This may have already been requested but I have the case where I'd like to create a Flow which pulls out Opportunities which haven't been touched in a week and sends an email containing an HTML table, listing these Opportunities. This works well, but I'd like to include the Owner name and at present if you pull in a lookup field you only get the GUID.
I've tried to use the 'Expand Query' option with owninguser($select=fullname) and although I can see the correct data in the output, it's not referenceable in the Dynamic Content in subsequent actions. I would like to request that if you use this Expand Query option, the selected fields from the related entity are included as Dynamic Content.
I am aware there's a workaround to 'Get Record' passing the owner GUID but because I need to put the output of this along with the 'List Records' output into an HTML table, I don't believe this is an option for me.
Hope that's clear - happy to discuss as needed - thanks!