Display related contact records of Accounts in a gallery in Canvas Apps using two gallery
Let us understand the scenario. I have an Account and there are multiple contacts associated with the Account and I want to display all Accounts in a Gallery and on the selection of Account from Accounts gallery the Contacts gallery will display all related contacts of that selected Account.
In this example we have to use Filter and AsType function to filter the Contacts by Accounts and provide the below formula on the items property of second gallery.
Filter(Contacts,AsType(‘Company Name’,[@Accounts]).’Account Name’ = Gallery1.Selected.’Account Name’)
