cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter gallery according to person column with multiple values allowed

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hi @Anonymous ,

 

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

 

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

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

 

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

 

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

 

View solution in original post

Anonymous
Not applicable

Thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,990)