cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vranjan22 Helper III
Helper III

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
Power Apps
Power Apps

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

6 REPLIES 6
mr-dang Community Champion
Community Champion

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 Community Champion
Community Champion

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
Highlighted
Community Support
Community Support

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
New Member

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?

Power Apps
Power Apps

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

kmk Helper IV
Helper IV

Re: upload excel table to sql database using PowerApp

Hi @vranjan22 / @Mr-Dang-MSFT@Mark-BM2018@Mark-BM2018 

is this issue fixed ...?

kindly help me too, yes same requirement here as well from Excel to SQL Table.

in between can use flow or powerapps.

if export from powerapps to SQL table that is well and good.

 

kindly share steps wise.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,022)