cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicepilarca
Level: Powered On

CDS 2.0 Lookup needs to show more fields

Hi! I created two entities in CDS that have a 1:N relationship with each other. I opened the child entity in Excel, but when I go to the lookup column, it only shows me two attributes of the parent entity: the GUID and the primary name. Is there any way I can pull the other fields of the parent entity in Excel or in CDS without making an app?

 

Thank you

3 REPLIES 3
Highlighted
rafaelb
Level: Powered On

Re: CDS 2.0 Lookup needs to show more fields

Hello,

 

Have you try to display you parent table as another soucetable and merge your first table using the Guid as key ? (Using Left Join)

nicepilarca
Level: Powered On

Re: CDS 2.0 Lookup needs to show more fields

Sorry I’m a bit new to this... how do I do joins in CDS?
AbeSaldana
Level: Powered On

Re: CDS 2.0 Lookup needs to show more fields

 I have created a blog post and video that explain the relationships on the CDS and Lookup fields

https://abesaldana.com/powerapps-canvas-using-lookups-with-cds/ 

Let me know if that helps, also I have other blog post and videos related to that topic. 

hope this helps!

 

abe

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 196 members 6,209 guests
Please welcome our newest community members: