You’re offline. This is a read only version of the page.
691
I can see that you have semi-colons, instead of commas.
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.
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.
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.
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
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
