cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vranjan22
Level 8

upload excel table to sql database using PowerApp

Hi,

 

I am looking for options/ways to upload excel file/csv to SQL table using PowerApps.

 

The objective is to update bulk records at once in SQL.

 

Please help.

 

Thanks,

Vivek

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: upload excel table to sql database using PowerApp

@Mark-BM2018, to open an msapp file, do these steps:

  1. Go to the PowerApps editor (create.powerapps.com)
  2. File > Open > browse for the msapp file

 

The import experience you're using is for exported zip files.

View solution in original post

5 REPLIES 5
mr-dang
Level 10

Re: upload excel table to sql database using PowerApp

Hi @vranjan22,

How do you feel about copy paste?

 

I have a solution you can copy data from an Excel spreadsheet (tabbed data) and paste it into a text input box. That data is split apart into a collection. And a button writes data to a datasource.

 

You'd just need to put in the column names and revise the formula for writing data a little bit to make it work.

 

https://aka.ms/pa/copypastecsv

 

Mr. Dang

_______

Microsoft Employee
@8bitclassroom
mr-dang
Level 10

Re: upload excel table to sql database using PowerApp

I should mention that the fastest and most efficient way to import records into SQL from Excel is to use the import wizard in SSMS. You can get thousands of records in there in seconds.

 

You can also use Collect() to write a bunch of records at once more efficiently, but you'll need to make sure the columns are exactly the same.

Collect(connected_table,local_collection) 

Brian

Microsoft Employee
@8bitclassroom
Community Support Team
Community Support Team

Re: upload excel table to sql database using PowerApp

Hi @vranjan22,

 

Here is the current situation:

1. PowerApps has no options available to upload a file and get its contents in a table format at the current time, the attachment control currently is only available with SharePoint List,

2. To work with Excel data within PowerApps, the Data within Excel file should be first formatted into a table, 

3. As @mr-dang mentioned, once you have connected the table within Excel, then it is available for you to bulk update records through collect() or forall() and patch().

4. Another workaround is to use Microsoft Flow within PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mark-BM2018
Level: Power Up

Re: upload excel table to sql database using PowerApp

Hi there, I get an error when trying to import the test PowerApp you created.  Am I missing something obvious?

Highlighted
Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: upload excel table to sql database using PowerApp

@Mark-BM2018, to open an msapp file, do these steps:

  1. Go to the PowerApps editor (create.powerapps.com)
  2. File > Open > browse for the msapp file

 

The import experience you're using is for exported zip files.

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,198)