Announcements
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
In the UNITE column of your gallery try changing your formula to ThisItem.Table2.Table3.ID, where
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.
.
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.
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.
I can see that you have semi-colons, instead of commas.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
