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.
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)