cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

SharePoint List View Threshold

Hi all.
I have a client that wants to use PowerApps to gather data. There will be in excess of 20,000 records a year. My question is will the 5000 list view threshold mean the app will fail or can I get round it with indexing and filtering records in the PowerApp or am I best to use SQL as the data backend.
3 REPLIES 3
Super User III
Super User III

@AlanRichards 

You can get around it the 5,000 record limit when FILTER by indexing the column you want to apply the filter on.

 

Start with SharePoint but consider a move to SQL if you can't overcome these 2 obstacles

 

  1. You need to use functions that can't be delegated in SharePoint such as SEARCH
  2. App performance is not acceptable given the amount of records (there's no hard limit here its just a preference thing).  You can use the performance monitor to time how long queries are taking.

 

Keep in mind if for SQL every user of the app will require a premium license @ $10 per app or $40 for unlimited apps.

 

 

Link To MS Blog Post Verifying My Claim

https://powerapps.microsoft.com/pt-br/blog/powerapps-now-supports-working-with-more-than-256-items-i...

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Hi
Thanks for this. I don’t use search in any of my app and try to just use filter.
I suppose my concern is that if the SP list has over 20,000 items will and new item form have any issues adding a new item to the list.

@AlanRichards
No, there will not be any issue at all.

At some point you may wish to move some records to history to increase performance when querying. You can accomplish this by setting up an identical list and using Flow to move older records automatically.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,753)