Answered

How to retrieve data from related Records in CDS

(0) Share

Report

Posted on by Emile_1944

Hi, using the example below(see hyperlink), what's the best way to retrieve the related records and display them in a view, for example? Remember there is no lookup column in this example. I am using Dataverse. Any idea would be helpful.

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-relate-unrelate

Thank you very much,

All responses (2)

Answers (1)

Emile_1944 34 on at

Like (0)

Report

Re: How to retrieve data from related Records in CDS

AhmedSalih, that works. And since I have 3 tables, I use 3 galleries to display data. I am also able to use each table as the parent gallery, and that gives me more options. I spent a long time trying to make this work, but it's working now. Thanks for your tips. Now I will see how I can put all of that data into a collection, but that's for later.
Verified answer

AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to retrieve data from related Records in CDS

Hello, @Emile_1944, If you are displaying them in a Canvas App. Use, your ParentTable.SelectedRecord.RelatedTable.
Usually I use a Gallery to show the Parent Table and another Gallery or Data Table to show the related Records in the Child Table.
1st Gallery Items Property: ParentTable Name
2nd Gallery/Data Table Items Property: 1stGallery.Selected.ChildTableName

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com