Filter gallery according to person column with multiple values allowed

(0) Share

Report

Posted on by Community Power Pla...

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)

Verified answer

Community Power Pla... on at

Like (3)

Report
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... on at

Like (1)

Report

Thank you!

Was this reply helpful? Yes No