Hi, I am trying to find a solution to allow an end user of my app to upload data from an excel template, to an existing dataset using a powerapps button or an attachment control.
The excel document template has the following columns headings, which are the same as the online dataset:
Product ID, Product Name, Price, Quantity, Total
Each day the end user will create a new excel document of the items of that day that will need to be uploaded each day.
My goal is to have a button in an app that allows the user to press a button, find the excel file from the day, and adds the data from the excel to the online dataset.
Can anyone advise me how to do this?
Thanks
Solved! Go to Solution.
You will not be able to do this in PowerApps as it does not interact with the file system like that and then process files.
You have really a couple of options:
1) Have users cut and paste the Excel table into your App
2) Utilize PowerAutomate to pick up the file from a common location and then process the records into a master list.
I hope this is helpful for you.
You will not be able to do this in PowerApps as it does not interact with the file system like that and then process files.
You have really a couple of options:
1) Have users cut and paste the Excel table into your App
2) Utilize PowerAutomate to pick up the file from a common location and then process the records into a master list.
I hope this is helpful for you.
Thanks
User | Count |
---|---|
252 | |
106 | |
88 | |
51 | |
44 |