Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

power automate Get Rows Error - paginated response

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I'm trying to run a power automate flow - get rows from SQL server view. It works fine for sometimes (for 7000 records) and some time I get the following error:

"The response is not a valid paginated response. The paginated response should not have the same non-empty 'nextLink' or 'odata.nextLink' property from the previous page when there are no items in the 'value' property."

The first step is "Recurrence" - once a day.

The second step is Get Rows. the pagination flag is turned on and the threshold is set to 100,000.

I don't have any access to the "dialog" between Get Rows and SQL Server. how can I affect nextLink? I'm not part of it.

 

Thanks,

Eran

 

 

  • Re: power automate Get Rows Error - paginated response

    Hi @eranzana 

     

    Just to double check, what connectors are you using? I remember I've seen a similar issue however it was related with the D365 connector so perhaps it is not the same.:
    https://powerusers.microsoft.com/t5/Building-Flows/List-rows-present-in-a-table-error-The-response-is-not-a-valid/td-p/404749

    https://powerusers.microsoft.com/t5/Using-Flows/Pagination-Error-Dynamics-365-Connector-List-Records-Action/m-p/404740

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics