
Announcements
Hi All,
I am using data verse tables in canvas apps. I have 'Entity A' which has a lookup of 'Entity B' and
'Entity B' which has a lookup of 'Entity C'.
I want to display the data in my gallery control grouped by 'Entity C' lookup
The Items property of my gallery control is set to 'Entity A'. How can i get the 'Entity C' Column in the Gallery and apply grouping based on it.
Kindly suggest.
Hi @Poweruser1101,
I would suggest you do something like:
ClearCollect(AddColumns('Entity A', "ColumnName", Lookup('Entity C', entitycid=Lookup('Entity B', entitybid=[@'Entity A'].'Entity B'.entitybid).entitycid).Name))
Thst syntax is probably not correct, but it gives you a rough idea on how to do it.