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

Insert list items to SQL Server

Hi All,

When I add a new item to a SPO list I would like FLOW to insert the data into a SQL server managed Instance DB table.

I know I saw something about this at SP Fest in Chicago last year, but I can't figure out how to do it.

 

Is it possible?

 

TIA,

Joe

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Insert list items to SQL Server

Hi @joef ,

 

You could create a flow with trigger "When an item is created" of sharepoint connector and an action "Insert row" action of sql Server conenctor, the flow should as screenshot below:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Insert list items to SQL Server

Hi @joef ,

 

You could create a flow with trigger "When an item is created" of sharepoint connector and an action "Insert row" action of sql Server conenctor, the flow should as screenshot below:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

joef
Level 8

Re: Insert list items to SQL Server

Thanks @v-alzhan-msft ,

I think I may be getting burnt by my firewall.  My test connection is failing, and I am using the same SQL Auth as I do thru SSMS.

 

Would you know where I can find documentation of what needs to be open between SPO and a SQL server Managed Instance in Azure?

 

Thanks again,

Joe

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,515)