cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jvang
Helper V
Helper V

Flow from Sharepoint list into SQL table

Hello,

 

I have two flows that I am testing and seems to fail when updating SP list into SQL table.

One flow goes on a infinite loop and I tried to turn the currency control to 1; however, it still goes on an infinite loop but says waiting as its status.

The other flow keeps failing when updating the SP list.

Any Ideas?

 

Thanks,

 

Jvang

 

test.PNGMS Ignite event.PNG

 

 

test3.PNGTestLabPA.PNG

6 REPLIES 6
PrasadAthalye
Community Champion
Community Champion

Can you open the running flow and see at which action it is in ?

 

Similarly can you open the 2nd flow where it shows waiting and see what does it show? It seems to be waiting on something...

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye,

 

It is in the insert action.

test.PNG

PrasadAthalye
Community Champion
Community Champion

okay looks like it is unable to connect to SQL. Are you using Azure SQL? Can you test connectivity?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye,

 

I am running on MS SQL.

Says that my status for the database is connected.

 

test.PNGtest3.PNG

PrasadAthalye
Community Champion
Community Champion

Can you change Insert command to a simple select * from table OR Select Top 10 * from <your table name> and see if that works. It appears that communication isnt happening.

 

Also are you using Azure SQL or On Premise?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye,

 

This would be in insert row settings or peek code settings?

 

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,601)