cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter BrowseGallery by User - 500s limit

Hey There, 

 

i just created my first App based on a SP List for recording working hours on different projects. I created all screens necessary for the recording of workin hours. Users can first select the clients, then with a distinct filter all orders by the selected client. In the next step they type in the number of hours on this project. The acutal date is suggested automatically and informations like order number, name of creator eg are deposited and will be delivered to the sp list.

 

In a BrowseGallery the Users should get a list of all recorded assignments. The Gallery is filtered by User and works fine in the moment. But i get a Warning because of the 500s limit. 

 

Do you have an idea how i can change my code to bypass the limit? the user-filter is necessary. The 500 records will be reached in about 2 month i guess. Furthermore, do you have experience how the performance of the app will be when there are some hundreds od records in the sp list.

 

Heres my Items-Code in the gallery:

 

SortByColumns(Filter(Zeiterfassung_Neu; Author.Email = User().Email;
StartsWith(Kunde; TextSearchBox1.Text) ||
StartsWith('LS/DL'; TextSearchBox1.Text)||
StartsWith(Kunde; Dropdown1.Selected.Value));
    "Datum";
 If(SortDescending1; SortOrder.Ascending; SortOrder.Descending)) 
 
 Thanks in advance for your replies.
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User III
Super User III

Hi @Anonymous 

It looks like Zeiterfassung_Neu.Author is a SharePoint Person field and unfortunately, it's not possible to filter this type of column with a delegable query.

Here's a link with more details:

https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/

The main workaround is to store the author email in a separate column.

 

View solution in original post

3 REPLIES 3
timl
Super User III
Super User III

Hi @Anonymous 

It looks like Zeiterfassung_Neu.Author is a SharePoint Person field and unfortunately, it's not possible to filter this type of column with a delegable query.

Here's a link with more details:

https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/

The main workaround is to store the author email in a separate column.

 

View solution in original post

Anonymous
Not applicable

Hi @timl 

 

thx for your fast reply!

I will try your described solution as given in your link. I will let you know if i made it work

 

😃

Anonymous
Not applicable

@timlThanks! I used the 2nd solution - everything is fine now

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,177)