cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henryed07
Helper III
Helper III

Power Apps Performance with large SharePoint lists

Just need clarify if my understanding is correct. 

 

I have some SharePoint lists that I will be applying a retention policy to, these lists after 6 years could have thousands of items in.

 

The End user, when using the list only need to see a fraction could be up to 10 or so items, but wont need to see the rest in the app - my understanding this won't have an impact of the App's performance as long as the filter/lookup is delegable....is that right? 

 

As i want to avoid having another list that Power Automate moves items to - so it's easier for reporting, etc.

1 ACCEPTED SOLUTION

Accepted Solutions
KvB1
Solution Specialist
Solution Specialist

I haven't had any performance issues with delegatable filter functions on large (60K+) datasets in powerapps, so I think youre good, as long as you make sure you have a good value that you can filter on with a delegatable function.

View solution in original post

3 REPLIES 3
KvB1
Solution Specialist
Solution Specialist

I haven't had any performance issues with delegatable filter functions on large (60K+) datasets in powerapps, so I think youre good, as long as you make sure you have a good value that you can filter on with a delegatable function.

View solution in original post

Nogueira1306
Community Champion
Community Champion

Hey! Yes, you should not have any problem. Just make sure on filter a delegatable function. If the values are unique, better

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

WarrenBelz
Super User
Super User

Hi @Henryed07 ,

I have with lists with 20,000+ items in them and they display galleries of matching items (generally 50-100) filtered on numbers or text on iPads in the field in seconds. They also resolve thumbnails of images from multiple Libraries (40,000 + items) in galleries on the same screen in not much longer. Does this assure your doubts?

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,951)