Announcements
I have an excel sheet with roughly 1,800 rows of data which is rapidly growing. However, for my app to process I only really need to load up the last 200 or so rows. Is there a way to filter my data so I'm only bringing in the latest data or is this only for sources that allow delegation?
P.S I am moving away from using Excel. I'm playing around with Sharepoint and SQL Server. I just need to get a bit more comfortable with those sources before I make any changes.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
You cannot delegate with excel. Go ahead with your switch to Sharepoint if you need to do this.
Hi @dyee4614
if you are importing the excel file into PowerApps, all the data is held in memory
In that case you could use
LastN(TableName,200)
Also check this post
https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
