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.
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...
okay looks like it is unable to connect to SQL. Are you using Azure SQL? Can you test connectivity?
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?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.