cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Export data from sql server to excel sheet in Sharepoint

Hi Dears,

I need to export data from table in sql server to excel sheet placed in SharePoint Location.

The flow should run daily and replace the previous day excel file with the updated data.

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

shure @cyberco01  see you need something like this

 

actions.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

8 REPLIES 8
Highlighted
Super User III
Super User III

hi @cyberco01  what you need to do first is create the excel file with a table and headers that could be used to storage your corresponding coumns from SQL.

 

To start your flow you need to use the trigger Schedule then you can see lots of configs about runing flow in a period of time.

Then you can use SQL conector to get rows from sql server and to end you need to use the action insert row in a table (excel) to save all your data collected from sql server conector get rows.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted

@ChristianAbata ,

Thanks for the response.

Kindly help me with an example or images as i am completely new to this.

Online reference with similar example will be helpful too.

 

Highlighted

shure @cyberco01  see you need something like this

 

actions.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

Highlighted

Hi @ChristianAbata ,

I tried the same.

Created an excel with rows similar to sql table.

Did the step Get rows > Add row into a table - in this step i filled the location, document library, file, for field table i am not getting any option in the table drop down of flow. on clicking the custom fields i get the column names as in SQL. I select one and it gets as a loop.

Kindly help

Flow1.PNG

Highlighted

@cyberco01  oh  this is because you need to create a table inside excel that contains the headers of the columns you need to populate.

 

See this video explaint how create a table https://www.youtube.com/watch?v=87EZ_J9E7_E



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted

Thanks @ChristianAbata .

I am trying the solution now. I will update you here soon.

Highlighted

Hi @ChristianAbata,

I tried the solution. My SQL Table has around 3000 rows or more.

The job is not completed yet. It is 4 hours and only 1000 rows are only updated.

Kindly advice.

 

Thanks,

 

Highlighted

@cyberco01  excellent friend if you solve your frist problem please try to mark an answer as solution then please open a new case to this new question, see this is just to keep order and help others to find answers



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

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