Answered

How do I have an Or in a Filter()?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a label that recognizes the user: Office365Users.MyProfile().JobTitle and then I also have a hidden label that says "All Roles". So, when a user accesses the app, I want the gallery to display all the items that are available to their role or all roles... and then I want them to be able to search within that.

Here's what I have the gallery set to:

Filter(ListName,ColumnName.Value in CurrentUsersLabel.Text Or AllRolesLabel.Text && searchbox.Text in Title)

It only returns the first logical test instead of both. Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Filter(ListName, (CurrentUsersLabel.Text in ColumnName.Value || AllRolesLabel.Text in ColumnName.Value) && searchbox.Text in Title)

ColumnName.Value - What type of column is this columnname?
Is it choice? - what values are part of this? is this multi select?

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RezaDorrani, So simple! Thank you! Right now, the column is a single-selection drop-down, but it needs to be a multi-selection. I've been researching how to first even display the multi-selection choices in the gallery and haven't made it that far yet. Suggestions?

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

It is little tricky

https://www.youtube.com/watch?v=44j2VRbdWjk

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No