55
I've built my first app using an Excel spreadsheet saved to OneDrive as the data source.
About 20 000 rows and 8 columns (basically a list of names and demorgaphics I want to be able to quickly search via the app)
I understand from searching that there is a 500 / 2000 row limit for searching
What's the best way around this limit so my app can search all tghe rows (preferably with a really simple ste-by-step guide)
Hi @RPNZ,
So far Excel delegation is still not yet supported.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list
There are a number of other data sources that do support delegation - such as SharePoint, SQL, Dynamics 365 etc. You could consider moving to one of these data sources in order to get delegation support.
Regards,
Mona
Share
Report
All responses (
Answers (
