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?
Solved! Go to Solution.
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:
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/
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:
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/
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
187 | |
70 | |
50 | |
37 | |
25 |
User | Count |
---|---|
240 | |
111 | |
91 | |
89 | |
67 |