cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AQ
Level: Powered On

How to check if user() exists on SharePoint list item which type is "Person or Group" ?

Hi all, I am new to PowerApps. Could anyone help me to lookinto this question  and let me know how to write the formula? Thanks.

 

I have a sharepoint which has a column called "Reviewer" which type is "Person or Group" , and allows multiple selection. Now I am creating a PowerApp and plan to show all the items which "Reviwer" contains current user. What should I write the formula in Powerapps. I tried as below, but it dosen't work.

 

Filter('Support List', Find(User().Email,Reviewer.Email)>0)

 

User().email = "D@ms.com"

 

SharePoint Name  - "Support List"

ID   Value   Reviwer

1     aaa     A@ms.com ; B@ms.com

2     bbb     A@ms.com ; B@ms.com ; D@ms.com

3     ccc      C@Anonymous.com

4     ccc      C@ms.com ; D@ms.com

 

PowerApps - the BrowseGallery is supposed to show after filtering

2     bbb     A@ms.com ; B@ms.com ; D@ms.com

4     ccc      C@ms.com ; D@ms.com

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to check if user() exists on SharePoint list item which type is "Person or Group"

Hi @AQ,

 

Please try this:

Filter('Support List', User().Email in Reviewer.Email)

See if this would show any results.

Further, there should be delegation issue related, see:

https://docs.microsoft.com/en-us/powerapps/delegation-overview

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: How to check if user() exists on SharePoint list item which type is "Person or Group"

Hi @AQ,

 

Please try this:

Filter('Support List', User().Email in Reviewer.Email)

See if this would show any results.

Further, there should be delegation issue related, see:

https://docs.microsoft.com/en-us/powerapps/delegation-overview

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
satya
Level: Powered On

Re: How to check if user() exists on SharePoint list item which type is "Person or Group"

Hi,

 

The above mentioned formula is not working with large item lists(having more than 2000 records). what is the best approach for the large item lists.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 144 members 4,454 guests
Please welcome our newest community members: