Filter gallery according to person column with multiple values allowed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have a gallery in PowerApps based on a SharePoint List that displays "Project Requests" (list items).
The SharePoint list has a person column that allows multiple entries for a "Business Manager".

In my gallery I want to show the logged in "Business Manager" which "Project requests" (list items) have chosen him/her as a Business Manager.

I have tried Filter('SharePoint List';'Business Manager'.Email=User().Email. But there is an error on the "=", stating that it is an invalid argument.

Does anyone know how to set the filter correctly?

Thank you

Dorothee

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try replacing the '=' in your formula with "in", like so:

Filter('SharePoint List'; User().Email in 'Business Manager'.Email)

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

Like (1)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No