
table A:
branch_id: auto_number
table B:
staff_id: auto_number
branch_id: whole_number
role text
table C:
staff_id: auto_number
name: text
galery 1: table a with branch_id selected
galery 2: i want to show galery with name(C),role(B) but have branch_id selected on galery1
Hello, @Emeralddream, Because PowerApps doesn't support Dataverse multilevel relationship. So you will need to use the Lookup Function:
In Gallery2.Items= Filter(table C, staff_id= LookUp(table B, branch_id=Gallery1.Selected. branch_id,staff_id))
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|