I have a lookup field in my CDS entity. I need to get the text value of it instead of the GUID.
Unfortunately, when I do a List Records action, I'm not seeing the text value of that lookup field anywhere. Is there any good way of returning that?
@Jcook that doesn't work for me. I can target the record with the GUID, but I don't return a text value of what is in the lookup. It just returns the same information.
I've got three entities. Facilities is the top entity. Trackers has a lookup to Facilities. Details has a lookup to Trackers.
Both lookups have the same TEXT values, but because they are lookups to different entities, they obviously have different GUID's.
If I do a trigger of record is updated, and take the GUID from that, pass it to a List Records where the Lookup field = returned GUID, I get the items I want but I still do not see a text value of that lookup field being returned.
Hmm. Yes I have multiple Flows and Logic Apps that do this and even more Custom Entities and Lookup's than you are doing.
Can you try using the Dynamics 365 connector to list records and see if any different values come up.
I think I ran into this issue long ago using the CDS connector. So i switched to using Dynamics 365.
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021