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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (20,507)