Unanswered

Improving a flow.

(0) Share

Report

Posted on by PA-09011222-0

Hello, I got a flow on power automate that I need help to improve the performance. The main problem that we're facing at the moment is with the timeout of the Response action. I got a Get Rows V2 checking my database to get invoices from a view from the last 3 months, the flow sometimes takes more than 2 minutes to run causing the Response action to fail. The volume of data the view responds to the Get Rows V2 action is around 20k rows. How can I improve this process? Thank you.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Gyllentid 894 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello, which data source are you using? It would be helpful to see a screenshot of the effected actions in the flow :)

Was this reply helpful? Yes No
PA-09011222-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@sroo I'm using SQL Server as the data source.

Was this reply helpful? Yes No
David_MA 15,422 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

As @sroo mentioned, it is helpful to show your flow as it provides a clearer idea of what you are doing. As the saying goes, a picture is worth a thousand words.

However, is the 20k rows the total number of rows in whatever you are pulling from? If so, add a filter query to just pull the values for the past three months.

Was this reply helpful? Yes No
PA-09011222-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

The view that the GetRowsV2 is using already has a filter to get the last 3 months.

Was this reply helpful? Yes No