web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery based o...

Power Apps

Answered

Filter Gallery based on 1 column but multiple values.

(0) Share

Report

Report

Posted on by niklasjegg

505

Hello.

i am building an APP where users can save their documents based on their department.

I have a Gallery with this filter:

Filter(Database_Test,Search_Gallery.Text in Title && 'Category' in UserDepartment)

I want to be able to Filter it base on :

Filter(Database_Test,Search_Gallery.Text in Title && 'Category' in UserDepartment && 'Category' in UserSecurity)

On Start i am generating the 2 variables based on 0365security groups and department.

How can i realize this. In case a User need access to another departments documents.

For example Category = IT and UserDepartment = IT but User Security = Finance. There exists a Category with the Value Finance.

do you know if this is possible??

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @niklasjegg ,

I think you need

Filter( Database_Test, Search_Gallery.Text in Title && ( 'Category' in UserDepartment || 'Category' in UserSecurity ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
niklasjegg 505 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz thanks a lot this works fine!

Now i just need to create security groups 🙂

Was this reply helpful? Yes No

Join the conversation