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
Super User
Super User

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

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

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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,896)