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.
Proud to be a Flownaut!
Proud to be a Flownaut!
Thank you so much!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
71 | |
22 | |
17 | |
17 | |
13 |
User | Count |
---|---|
126 | |
35 | |
30 | |
28 | |
26 |