I'm using a flow to create word documents containing data from a CDS entity.
Normally I would use Select and do it easily like this screenshot example:
but the "site" field is a Lookup entity, and therefore the dynamic content coming from the CDS flow action is only the GUID. I do not get the Name (primary field), only the GUID. So I can't map it with the dynamic content.
The solution I found is a nested loop with a condition like this:
but loops with conditions take time... nested loops take exponentially longer. I dread using this solution as it will make this flow's runtime extend from a few seconds to several minutes long.
Is there any way I can dynamically add the Site name from the lookup entity into the Select action?
Like filter/switch code I could put into the mapping value...
It seems like such a small thing that I need such a huge mess of a flow for.
Solved! Go to Solution.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!