cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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
Super User III
Super User III

Hi @THN_Hlmn 

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
Super User III
Super User III

Hi @THN_Hlmn 

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

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

 

😃

Regular Visitor

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

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,997)