Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Filtering Gallery by Dataverse Relational Table fields

Posted on by 38

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:

Rajeey3_0-1621516133864.png

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?

  • CNT Profile Picture
    CNT 10,926 on at
    Re: Filtering Gallery by Dataverse Relational Table fields

    @Rajeey3 Can you share as screen shot please.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard

Featured topics