View data from Dataverse in a gallery

(0) Share

Report

Posted on by Hii_iii

691

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

mbatutie 14 on at

Like (0)

Report

Hi, it's a long video, but it's very good - about dataverse relationships and displaying them in galleries.
https://www.youtube.com/watch?v=7fj87TAaTvw

Was this reply helpful? Yes No
Siyanda_007 13 on at

Like (0)

Report
In the UNITE column of your gallery try changing your formula to ThisItem.Table2.Table3.ID, where
ThisItem: Refers to the current item in your Gallery_1.
Table2: Navigates from the current item to the related item in Table2 based on your Many-to-One relationship.
Table3: Navigates from the related Table2 item to the related item in Table3.
ID: Retrieves the ID field from Table3.
But also make sure that the Items property of your Gallery_1 is set to your Table1, so the formula would be the name of your data source which Table1 according to your question.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Siyanda_007 13 on at

Like (0)

Report
The error you're facing suggest that it's possible that the relationships or the specific syntax used in the formula might need adjustment but here's another formula you can try to avoid such an error.
Replace ThisItem.Table2.Table3.ID with:
LookUp(Table3, Table2Table3.Table2Table3 = LookUp(Table2, Table1Table2.Table1Table2 = ThisItem.Table1Table2.Table1Table2).Table2Table3.Table2Table3).ID
LookUp(Table2, Table1Table2.Table1Table2 = ThisItem.Table1Table2.Table1Table2): This part looks up the related record in Table2 based on the relationship with Table1.
LookUp(Table3, Table2Table3.Table2Table3 = ...): This part looks up the related record in Table3 based on the relationship with Table2.
.ID: Finally, it retrieves the ID field from the found record in Table3.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Siyanda_007 13 on at

Like (0)

Report

Yes, I apologize for not mentioning it earlier but it is the name of your relationships which are also known as connections, the relationship between your tables. You can find them through Power Apps portal, go to the environment where your tables are located once you located the tables. Look for the "relationships" or "connections" tab then view the relationships.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Siyanda_007 13 on at

Like (0)

Report

I can see that you have semi-colons, instead of commas.

Was this reply helpful? Yes No