cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
New Member

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)

Highlighted
Frequent Visitor

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?
Helper II
Helper II

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,928)