cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Filter on more than one value

Hi,

Anybody that can help me out. I wish to filter on this

Filter(Onboarding,Office365Users.MyProfileV2().department in Department.Value, 'Status/date' = Gallery3.Selected.'Status/date' )

So I have some courses that is relevant for some departments only, that the assigned department member should be able to see. But I also want to divide it like active, done and so on, so the member can keep track. 

 

app3.PNG

But when I use the code above nothing happen.

 App4.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Filter on more than one value

I solved it using this code:

Filter('Onboarding','Status/date' = Gallery3.Selected.'Status/date', Office365Users.MyProfileV2().department in Department.Value)

It was not reading my list, that is why I did not see any

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Filter on more than one value

@JHS 

First things first, you appear to be getting a delegation warning.  How many rows in your datasource table?  Have you bumped up the delegation limit to 2,000 rows in the advanced settings?

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Helper I
Helper I

Re: Filter on more than one value

I have 15 items

Highlighted
Helper I
Helper I

Re: Filter on more than one value

I solved it using this code:

Filter('Onboarding','Status/date' = Gallery3.Selected.'Status/date', Office365Users.MyProfileV2().department in Department.Value)

It was not reading my list, that is why I did not see any

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,119)