cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Use MS Flow to copy excel contents to sql server

I have an excel file stored in a Sharepoint 365 doc library. I am trying to copy all the data from a table in the excel file into SQL Server.

 

I was using the "list rows present in a table (preview)" flow but it seems limited to 256 rows and I can see a way of increasing that limit.

 

I am finding it difficult to find an appropriate connector for doing this. There are other excel connections but they are for excel files stored on OneDrive or on your local file system. What is the appropriate connector for connecting to an excel file on Sharepoint?

Thanks

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Use MS Flow to copy excel contents to sql server

Hi @niallhannon,

 

Could you please share a screenshot of your flow's configuration?

Do you use the "List rows present in a table" action of Excel Online (Business) connector to get rows from the Excel file stored in your SP library?

 

I think the only available connector for connecting to an Excel file on SP library is the Excel Online (Business) connector in Microsoft Flow currently.

 

I think your thought is correct, the "List rows present in a table" action of Excel Online (Business) connector could only retrieve 256 rows at most once time. If you want the "List rows present in a table" action could retrieve all the items in the list once time, you could consider take a try to enable the Pagination property within the Settings option of the "List rows present in a table" action as below:14.JPG

 

 

More details about enabling the Pagination option in action settings, please check the following article:

https://flow.microsoft.com/en-us/blog/four-connector-action-settings/

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Use MS Flow to copy excel contents to sql server

Thanks the pagenation option solved it. 

Highlighted
Administrator
Administrator

Re: Use MS Flow to copy excel contents to sql server

Hello, @niallhannon !

 

Have you had a chance to apply @v-xida-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

 

Thank you for being an active member of the Flow Community!

 

-Gabriel

Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
Frequent Visitor

Re: Use MS Flow to copy excel contents to sql server

Can you share flow,how you did this?
I am new here,wanted to do the same.
thnaks

Highlighted
Frequent Visitor

Re: Use MS Flow to copy excel contents to sql server

Can you please share the flow on how to do this, is there any ways if I only want to copy certain column? Thank you 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (5,057)