Combining filters on sharepoint list on person and group columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear Team,

I want to filter a sharepoint list based on the following criteria:

My List is having 3 columns, namely:

1.) Owner - which is a person or group column

2.) Author - By default our - Sharepoint person or group column

3.) Contributor - which is Multiple person or group column

A filtered item of the list would be related to the user if his name appears in any of the 3 above columns.

At the onstart of the app I get the mail id from the User().

then I need to apply check on First(Split(varUser.Email,"@")).Result. Suppose my mail Id is abcxyz123@pqrs.in

then after first split... code returns me abcxyz123. Now I want to check whether this text i.e. abcxyz123 is in Onwer mail id, Contributors (multiple persons column), or Author. If yes, then filter else do not filter.

Please suggest proper method to do this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous

It would roughly be close to this:
Set(varUser, First(Split(User().Email,"@")).Result) If(varUser in Owner.Email && varUser in Concat(Contributor,Email,"#") && varUser in Author.Email , ...... YOUR FILTER CONDITION HERE...... )

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

You can filter your SharePoint list by checking all three columns for the owner mail ID then save it to a new collection (e.g. colMyList) as follows:
Set(colMyList, Filter(MySharePointList, gblOwnerMailId in Owner|| gblOwnerMailId in Author || gblOwnerMailId in Contributor));

in and exactin operators reference: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators#in-and-exactin-operators
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

The concat function is helpful in navigation through the multiple persons column. Thank You for suggesting it.

Was this reply helpful? Yes No