Answered

How to retrieve data from the child table in lookup

(0) Share

Report

Posted on by Daved1

166

I have 2 tables - 1 is Document master, and 2 is Document Revision. A master document can have many revisions, so i setup a 1:N relationship by adding a lookup field in the Document Revision table.

I have a Canvas app with a gallery control linked to a collection based on the Document Master table. I want to include the latest dcoument revision number from the linked Document Revision Table.

I am confused because the lookup field is in the Document Revision table. How do i pull data in the opposite direction (from the Master Document table). The relationship was created between the 2 tables. I am just not sure how to reference it from the Master Documents Table (no field)

Thanks

Dave

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Daved1 166 on at

Like (1)

Report
Copy link

Link copied!

I think I was thinking of the wrong solution. I was trying to add to my Master Document collection data from my child table, so i could display this in the Gallery view.

Instead, i just used Lookup() to lookup the value in the child table. seems to work OK and does what i wanted, so i am happy.

sorry for posting then answering my own post

Dave

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Daved1 ，

Has your problem been solved?

If so, you could mark your reply as a solution to help others in need. And the case will be closed. Thanks.

Best Regards,

Wearsky

Was this reply helpful? Yes No