Can a user upload an Excel-File into the App while using it?

[Phil_Thurner]

Hello everybody,

i have a question regarding the following topic: About 10 variables should be set/assigned by the user for further calculation. It would be great if there is a possibility that the user fills an excel table (on his PC) with the values of the variables and then uploads the file into the PowerApp while using it. Is there a possibility to do so?

Or has anybody an alternative?

Best wishes

[BCLS776 · Accepted solution]

Yes, you can do this and have it work well with the app. For best results, set it up like this:

• The Excel file has a Table that contains your values
• The Excel file is connected to your app as a data source prior to runtime

Then your app can read/write to that Excel file using Form controls or Patch() as you need.

Hope that helps,

Bryan

[Phil_Thurner]

Alright I will try your proposal, thank you!

BR,

Phil