cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RussellGove
Kudo Kingpin
Kudo Kingpin

Filter on SharePoint User email not working

HI,

I am trying to filter a  sharepoint list based on a user column. 

In the past, i remeber using the expression 

Filter('Business Role Owners',PrimaryApprover.Email = "john.doe@gmail.com") 

to filter a sharepoint list based on the email address of the 'Person' column called PrimaryApprover.

 

 

This is not working anymore due to some delegation issue. It only returns records from the first 500 rows that have a matching email. 

 

Also, the 'blue dot' is gone, now it is a yellow warning sign.... when did that happen?

 

How can I find all the items in a large sharepoint list for a selected user?

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Thorpe
Super User
Super User

The person column in SharePoint has never been delegable. PowerApps did recently make some changes to the error messages and the blue dot is no longer used. Instead you will get a yellow triangle as warning when using a non-delegable formula. If your list is under 2,000 then you can increase the default non-delegable query limit up to 2,000.

 

Here is a blog post that talks about all the error handling improvements:

https://powerapps.microsoft.com/en-us/blog/new-app-checker-helps-you-fix-errors-and-make-accessible-...

 

Blog post on PowerApps data row limit for non-delegable queries

https://powerapps.microsoft.com/en-us/blog/powerapps-data-row-limit-for-non-delegable-queries/



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

The person column in SharePoint has never been delegable. PowerApps did recently make some changes to the error messages and the blue dot is no longer used. Instead you will get a yellow triangle as warning when using a non-delegable formula. If your list is under 2,000 then you can increase the default non-delegable query limit up to 2,000.

 

Here is a blog post that talks about all the error handling improvements:

https://powerapps.microsoft.com/en-us/blog/new-app-checker-helps-you-fix-errors-and-make-accessible-...

 

Blog post on PowerApps data row limit for non-delegable queries

https://powerapps.microsoft.com/en-us/blog/powerapps-data-row-limit-for-non-delegable-queries/



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Lexnnn
Helper II
Helper II

This did help me to filter on User = email from people field: (I was using people field and it did not work well with powerapps) (3200+ items)
https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/

Solution in short: use variable "on start" + "OnVisisble" refresh of the list and use same variable in filter +  single line of text field instead of poeple field.

SortByColumns(Filter('Sandwich shop',(Salesrepemail = CurrentUser.Email) And ((StartsWith(Account_x0020_name, TextSearchBox1.Text)) Or (StartsWith(Street, TextSearchBox1.Text)) Or (StartsWith(City, TextSearchBox1.Text))Or (StartsWith(Postal_x0020_Code, TextSearchBox1.Text)))), "Account_x0020_name", If(SortDescending1, Descending, Ascending))

 

To let the users still be able to use the people field, I use flow to auto populate the new single line of text field with a copy of email adress from people field.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,556)