web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering people picke...

Power Apps

Unanswered

Filtering people picker value as Email from AssginedTo column from Sharepoint

(0) Share

Report

Report

Posted on by appuser5

20

I have a list called UserStudent,

Columns

Name- Single line of text

UserEmails- People Picker

Phone no-Single line of text

I am filtering this in gallery of power apps, but i tried lower case and provide varUserEmail in start up by setting Set(varUserEmail,User().Email).

But i can't able to filter data's related to that and facing delegation issue.

Basically trying to getting people picker value from list is the issue it seems.

Filter part in my gallery

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Here's a good article on avoiding delegation issues.
https://www.powerobjects.com/blog/2019/03/04/delegation-warnings-powerapps/
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @appuser5 ,

I've searched delegateable functions of sharepoint list.

I found that filter for complex type is delegateable, while Lower isn't.

And the people field's Email data and User().Email do not have the problem of letter case.

So please do not use Lower() function in your formula to avoid the effect of delegation.

Try this formula:

Filter(...,varUserEmail=UserEmails.Email)

Here are the delegateable functions of sharepoint for your reference:

Best regards,
appuser5 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Tried the syntax that you provided, but the filter is not working with "no records", but the list have 10 records.
Filter(User_Priveleges,UserEmails.Email=varUserEmail)
Attached screen shot, do i need to add/change anything

Join the conversation