Hi PowerApps Community,
I have a Users table which includes UserID, I have a Business Unit table which includes BUID.
I have created a relational table called UsersBUAccesses that has 2 lookup columns, one to the Users table and one to the Business Unit table. See Below:
I am trying to filter a gallery of data that's datasource is "SalaryData" which includes a field called 'Business Unit'.
In the onVisible property of the screen I have this code:
Set(LoggedInUserID, LookUp(Users, 'Email Address' = LoggedInUserEmail,'Employee ID'));
Set(AvailableBUs,Filter(UserBUAccesses, EmpID.'Employee ID' = LoggedInUserID));
Here is the filter code I am trying to filter the gallery:
Filter(SalaryData,'Business Unit' in AvailableBUs.BUID.'Business Unit')
There is no data returning even though above you can see I, "Aaron Rogers", have 2 business units.
I ran a CountRows on the gallery and can see that there is 2 rows but again no data is showing.
Anyone have any ideas?