I'm working from an excel file that has 15000+ records. When i try to filter some items it won't show it all. I did some research and found that the max records that powerapps will allow is 2000. But i don't think this is the issue cause it is filtering data beyond the first 2000 records.
Can someone help me please?
Solved! Go to Solution.
I know Sequence() is the best for future maintenance, but I tried with a list that have 13,5k items (yes I had that solution implemented before) and the difference of loading data was from 25 seconds Sequence() to 5 seconds with the Concurrent(). Of course if the list grows like 100 items per day, the Sequence() gives you better control because you don't need to change/add more collections. Both options have ups and downs, we just have to think what is the best for us, our app and the user 😊 sorry for the double post with same solution, but never thought about the batch option and was so excited to share 😅 cheers
That's interesting feedback re the timings. I wondered how Sequence would fare. I don't have a list large enough to test it on so didn't know if it would be slow or not.
I might have to see if I can work some Concurrent magic into that method 🙂
I've written an article showing 4 different ways to Create Power Apps Collections Over 2,000 rows. You can check it out below.
Link to Article:
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."
Check out the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.