Filtering current user in a multi-person column

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I have a SP List with a person type column which may include multiple owners/persons in a single row.

In my app gallery, I need to display only those rows in which the current user is one of the owners.

I am aware that I will hit the delgation warning if I try to check against a person field in SP List.

Can someone suggest a workaround please?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Verified answer

v-yuxima-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

Hi @Anonymous ,

What formula expression do you use now?

If you just get the warning it is just warning, not the error.

More details about delegation:

understand delegation in cavas-app

I test on my side also has the delegation(as App test1):

Filter('20190226filtermultipleperson',User().FullName in ShowColumns(PersonM,"DisplayName")) (‘20190226filtermultipleperson’ is my sp list name)

If you do not want the delegation warning, you could try to use the collection to collect your data firstly,and then filter.(As App test2)

App test1:

App test2:

Add one button control and then Button5.OnSelect: ClearCollect(test,'20190226filtermultipleperson')

And then Gallery3.Items: Filter(test,User().FullName in PersonM.DisplayName)

Hope this can be helpful.

Best Regards.

Yumia

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

Like (0)

Report
Copy link

Link copied!
@v-yuxima-msft
Thank you Yumia.
App2 works fine when I collect the records first. The gallery lists my records
Filter(AllRecords,Me in SPOCs.Email)
Allrecords is set to ClearCollect(AllRecords,'Logical Access')

But App1 throws a deleagtion warning and no records are fetched.
Filter('Exception Tracker',Me in ShowColumns(SPOCs,"Email")
SPOCs is the mutiperson column in SP List and me is set to Office365Users.MyProfile().Mail

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please try to use User().Email to instead of Me in your formula expression to test?

Filter('Exception Tracker',Me in ShowColumns(SPOCs,"Email")

Best Regards.

Yumia

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Filter('Exception Tracker',Me in ShowColumns(SPOCs,"Email")) (please do not miss ")")

Best Regards.

Yumia

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

Like (0)

Report
Copy link

Link copied!

Hi @v-yuxima-msft

User().email will not work in my case because it fetched me email in a different format.
User().email gives me <mailnickname or employee id>@domain.com

In my SP persons column the email feteches me <firstname>.<lastname>@domain.com

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

Like (0)

Report
Copy link

Link copied!

Hey @v-yuxima-msft , it worked !!!

Thank you very much
It wasn't working in the app but works when published.

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You are welcome.

Best Regards.

Yumia

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

Like (0)

Report
Copy link

Link copied!

@v-yuxima-msft The line is now giving me problems. My total records have exceeded 2000 in SP list and new records are no longer fetched due to the delegation issue. Please help.

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you please change the value to 2000(File->App settings->Advanced settings)?

And could you please reference:

https://powerusers.microsoft.com/t5/General-Discussion/500-rows-limit/td-p/93826

Hope this could be helpful.

Best Regards.

Yumia

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

Like (0)

Report
Copy link

Link copied!

@v-yuxima-msft , i tried your app test 2 method, there isn't any error or delegation warning but it isn't working for me,
am trying to filter the project IDs for the current user in the dropdown from a multi person column, can you help me

Was this reply helpful? Yes No