One Drive Excel file size limit Issue

[amsrivas]

Hi Folks!!

I have source file at OneDrive business which is of 500KB.

Power App is connected to this excel file and as soon as Power APP creating its PowerApp_Id in the excel, size of the excel shoots up to above 2 MB. And,  as soon as size goes above 2MB, PowerApp Crashes.

Any suggestion to resolve the issue

Thanks

Amit

[timl · Accepted solution]

Hi Amit,

There is no way to resolve this 2MB limit.

The only thing I can suggest is to split your data across two separate Excel files.

You would then need to adapt your app so that in places where you display data, you combine the data from both files.