Solved: Excel Record Limitation for searching

Anonymous · ‎10-10-2018

Hi,

I have an Excel sheet with over 40K records and I want to make an app (only web version work on PC not mobile) just for searching, it has a limit of 2000 if I connected my app to excel in OneDrive (for example) and about 15000 if I uploaded from PC in PowerApps studio.

When I search something after 2000 or 15000 the result is empty.

How can I avoid any limitation? If not possible can you guys reccomend a service doing so? (Only for searching puposes)

Thanks in advance...

Anonymous · ‎10-10-2018

Hello Reberov,

There is unfortunatelly no real workaround that limitation with Excel/Onedrive.

This row limitation exists because at the moment PowerApps (web-based) is not able to look through too many data (or else your app would be VERY slow). The work around is to delegate the search function to the datasource itself (unfortunatelly Excel cannot use it).

For example if you search through 15000 records instead of your PowerApps doing the Search your app sends the info to a SharePoint list which will execute the search (assuming the data is already in a SP list). Once SP is done it will return the search results to the app.

I suggest you change your datasource to a Delegable datasource listed here : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list.

View solution in original post

Anonymous · ‎10-10-2018

Hello Reberov,

There is unfortunatelly no real workaround that limitation with Excel/Onedrive.

This row limitation exists because at the moment PowerApps (web-based) is not able to look through too many data (or else your app would be VERY slow). The work around is to delegate the search function to the datasource itself (unfortunatelly Excel cannot use it).

For example if you search through 15000 records instead of your PowerApps doing the Search your app sends the info to a SharePoint list which will execute the search (assuming the data is already in a SP list). Once SP is done it will return the search results to the app.

I suggest you change your datasource to a Delegable datasource listed here : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list.

Anonymous · ‎10-10-2018

Thnaks for your response, unfortunetly even SharePoint List didnt work for me.

Do you know any alternative serivce? a service that I put my data then search. Web based.

Anonymous · ‎10-10-2018

I suggest you check out the link I left above and see by yourself which would fit you.

Any other sources are limited (don't quote me on that I'm not 100% sure of that), for this amount of records a SQL database can be what you need. If you have trouble with your sharepoint check Youtube or the forum for some tutorials.