cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nagaviswanath Kudo Collector
Kudo Collector

Excel -One drive; Any limitations for data storing/filtering?

Hello,

 

Can someone shed light on how much data can excel store on one drive. I am using 2 excels files for my timesheet application to store data of the 30+ users. And also i am using Gallery items to display the timesheet entries of selected month by user.

 

For every month, each user can insert max of 100 rows in a single file totalling close to 3000 rows and the number increases every month. Does Excel file in Onedrive can handle such amount of data? If so, will it filter and display the results of selected month as said earlier.

 

Awaiting for the information.

 

Kind regards,

Naga

 

3 REPLIES 3
Community Support
Community Support

Re: Excel -One drive; Any limitations for data storing/filtering?

Hi @Nagaviswanath,

 

For Data storage in Excel, please check:

Excel specifications and limits

For OneDrive storage and the corresponding plan, please check:

OneDrive storage plan and billing questions

OneDrive for Business

 

For data filtering, currently there is delegation limitation within PowerApps for Excel.

Please check the article below:

Delegable data srouces

Which mentions that Excel is not supported for delegation under PowerApps, means PowerApps would impose a limit on the amount of data that can be processed locally: 500 records.

Understand delegation

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nagaviswanath Kudo Collector
Kudo Collector

Re: Excel -One drive; Any limitations for data storing/filtering?

Hello Michael,

 

Sorry i was bit confused on 500 rows limitation. So, Powerapps cannot retrieve data correctly if the data is more than 500 rows in the excel file (which acts as datasource) or it cannot show more than 500 rows in the app if we use Filter/Lookup functions.

 

I will tell you my requirement to know it in better way. 30+ users add their timesheet entries every month adding ~ 3000 rows to the excel file. And we have below screen which shows the user's selected month timesheet entries (i.e., max 30 rows).

 

I am using this formula: Filter(Table1, User = TextBox26.Text, Month= TextBox22.Text, Year=TextBox25.Text)

Will it work properly?

 

Display_Month sheet.PNG

 

 

Nagaviswanath Kudo Collector
Kudo Collector

Re: Excel -One drive; Any limitations for data storing/filtering?

Hello @v-micsh-msft

 

Do you have any update on this when we can filter the rows from the excel containing above 500 rows.

This is really making my application useless for my company.

 

Kind regards,

Naga

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (8,085)