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

Search, filter and Delete from sharepoint list having greater than 5000 records(in Powerapps)

Hi All,

 

Kindly help in deletion of record from sharepoint list having more than 5000 records. I am using the Below query in Remove function of powerapp Details form delete button on select event.

 

Remove('datasource',gallery.selected),

 

and please help me how can I filter more than 5000 records using choice fields and Date fields with non delegable functions.

 

Filter('Datasource',Type.Value= "Article")

2 REPLIES 2
leyburn19
Memorable Member
Memorable Member

Filter('Datasource',Type.Value= "Article")   should not present any delegation issue. The = is delagable.  It is operators like <> that are not,  which makes working with dates an issue

 

You can increaes the delegation from 500 to 2000 now in teh experimental settings but this can have performance side effects as it becomes client side not server.

 

I do a lot of work arounds using collections and sorting etc.  As an example  say you want to filter a source based on a date range that would always be in the last 500 records. I do my filter like this:

 

Filter(sort(datasource,ID,Descending),source.date1<=Vardate And Source.date2>=Vardate)

 

Like everything in maths,  it does the Brackets first which Sort() is delegable.  It sorts the datasource descending first which then make the last 500 records avaialable for filtering based on a varaible date in between two column dates. If you have more than the possible 500 to get a result then this can be increased to 2000

 

While the delgation presents issues I have found work arounds every time.  It is a shame though that SharePont cannot do anything than equals at this time.  Sort of makes its future questionable in the terms of this way ahead.

 

v-xida-msft
Community Support
Community Support

Hi @Anonymous,

 

I agree with @leyburn19's thought almost. Currently, the SharePoint data source could only support Equals (=), And (&&), Or (||) and StartsWith Filter and Lookup delegable predicates.

 

If you want to filter a SharePoint data source based on a date range without Non-delegable functions within your PowerApps app, I afraid that there is no way to achieve your needs in PowerApps currently.

 

More details about list of data sources and supported delegation, please check the following article:

List of data sources and supported delegation

 

More details about Delegable functions and Non-delegable functions in PowerApps, please check the following article:

Understand delegation

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Top Kudoed Authors
Users online (1,660)