Button to extract data from excel file that automatically adds data to existing dataset.

[SG1990-2]

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

[RandyHayes · Accepted solution]

@SG1990-2 

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.

[SG1990-2]

Thanks