cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Getting the text value of CDS Lookup?

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?

10 REPLIES 10
Highlighted
Super User III
Super User III

Re: Getting the text value of CDS Lookup?

Hello,

Could you share a picture of your configuration for your flow,

If you use the guid and use a get record on the entity the lookup is from and from there you can get the text value.

For example if I have the guid for a particular user from the ‘users’ entity. I can use a get records on the users entity and use Odata filter like:
users eq ‘<guid>’
After that I can use a compose shape and get the users full name from the get record.

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Post Patron
Post Patron

Re: Getting the text value of CDS Lookup?

 

@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.

 

2020-01-30 08_07_35-_new 9 - Notepad++.png

Highlighted
Super User III
Super User III

Re: Getting the text value of CDS Lookup?

Hello,

Take the guid from the picture you posted, and use a ‘Get Record’ on the entity where the lookup is coming from.

**Please share your configuration for your Flow**

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Post Patron
Post Patron

Re: Getting the text value of CDS Lookup?

You want me to repeat the list records, matching the GUID to itself?

 

2020-01-30 08_29_23-Edit your flow _ Power Automate.png

Highlighted
Super User III
Super User III

Re: Getting the text value of CDS Lookup?

Yea, so if I am getting this correct.

After your List Records action add a ‘Get Record’

And use the guid on the entity where the lookup is being looked up from. Which in this case I believe is the Facility entity.

Let me know, if it does not work

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Post Patron
Post Patron

Re: Getting the text value of CDS Lookup?

It returned the same information.

Highlighted
Super User III
Super User III

Re: Getting the text value of CDS Lookup?

Hello,
So if you use A compose Shape under that, what values can you select as an input?

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Post Patron
Post Patron

Re: Getting the text value of CDS Lookup?

The exact same.

Highlighted
Post Patron
Post Patron

Re: Getting the text value of CDS Lookup?

@Jcook have you done this same setup with two custom entities? I'd be interested to know if it works for you. I don't believe I've done anything unique in my setup here.

Highlighted
Super User III
Super User III

Re: Getting the text value of CDS Lookup?

@notj 

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.

 

Thanks

 

--Josh

 

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,860)