i'm creating an app that uses imported data source from Excel file the problem is that i want to read 200,000 rows at least, but i dont know if i can do that or how i can do that because first, i increase the limit of data in the config from 500 to 2,000 rows and then i'm also using a formula that i think is a delegation function: Search("my_Excel_file";TextSearchBox2.Text;"Column1";"Colmn2")
I'm using this function in a Browse Gallery and when i try to know how many data i'm reading, i use this function:
but the result is only 15,000, not thw 200,000 rows i need.
I need help cuz i don know how can i read the 200,000 rows
Actually, it is the known limits with 'Add static data to your app' feature in PowerApps. The 'Add static data to your app' feature can only load a maximum of 15,000 records once time.
If you want to load more than 15,000 records from your static Excel file, as an fixed solution, you could consider bulk-load your Excel data into your app to multiple individual collections, then merge these individual collections into a single one collection, then use the single one collection as data source in your app.
Please check and see if the following blog would help in your scenario: