web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Answered

SQL Server Get Rows

(0) ShareShare
ReportReport
Posted on by 144

Hi,

I have a erratic Get Rows problem with my flow. You can see the settings in the images below. The problem is that it's very flaky in the way that it sometimes works, but sometimes fails with the error message in the last image. I have tested it with the exact same data and I will still get a fail rate of around 6/10. Anyone had this type of experience and if so, did you manage to overcome it?

 

GetRowsSettings.PNGGetRowsSettings2.PNGGetRowsSettings3.PNG

Categories:
I have the same question (0)
  • Verified answer
    v-litu-msft Profile Picture
    on at

    Hi @McMonty,

     

    I have never met this issue because I have no such amount of rows.

    But there is a method to prevent the action failed, you can nest the Get rows into a Do until action, it will be a loop if the Get rows always failed. If the statusCode of Get rows is 200, jump the loop.Annotation 2019-11-18 151840.png

     To prevent the following action will stop due to the Do until action will be regarded as failed one if Get rows failed firstly, you should Configure run after in the next action, select "has failed" will let the action continue work if the Do until failed.

    Annotation 2019-11-18 152228.png

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard