Power Platform Community Forum Thread Details

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

Categories:

Using connectors