SQL 'Get rows V2' not returning an array of rows or an empty array

(0) Share

Report

Posted on by MichelH

401

Recently some of my flows fail, because the SQL 'Get rows V2' not longer returns an array of rows or an empty array.

In my understanding, SQL 'Get rows V2' should return an array of rows or an empty array, not this.

SQL Server - Connectors
MS documentation says the same, "This operation gets rows from a table."

While I can adjust the flows to test if the output is an array, I seek to understand what is going on.
Is this the intended behavior?
What purpose could it possibly serve?

Thanks for any feedback.

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

what does it return now?

Was this reply helpful? Yes No
MichelH 401 on at

Like (0)

Report

Well, it returned this :

Which is wrong,... 0001063079 should have given me 13 lines, I see in the DB,.....
But resubmitting the flow now gives me the correct answer, an array of 13 lines.
I see it occasionally does this.
I guess I don't need to solve any coding issues here.

I need to force it to behave,.. to act normal. 😩

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

Maybe try with "Execute a Query" instead

or, if you get a note that that is not supported - "Run a Stored Procedure"

Was this reply helpful? Yes No
MichelH 401 on at

Like (0)

Report
Thank you for thinking along @lbendlin

I may have a look what is the most error prone power automate flow in this matter and in there, replace the 'get rows V2' by a execute stored procedure to see if this doesn't produce incoherent responses.

I can't do a execute SQL query, because the database is an on premises database, that I need to access via a gateway.
(I should have mentioned that.)
{ "@odata.context": "https://flow-apim-europe-002-westeurope-01.azure-apim.net/apim/sql/cdfdce37856856d47788fc1936e0c0f0/$metadata#datasets('EUXXXXXXXXX3%2CBE_DB')/tables('%5Bdbo%5D.%5BZ4_TABLE%5D')/items", "value": [] }

or

{ "@odata.context": "https://flow-apim-europe-002-westeurope-01.azure-apim.net/apim/sql/cdfdce37856856d47788fc1936e0c0f0/$metadata#datasets('EUXXXXXXXXX3%2CBE_DB')/tables('%5Bdbo%5D.%5BZ4_TABLE%5D')/items", "value": [ { "@odata.etag": "", "ItemInternalId": "5b31e381-57fb-47a9-b98c-a39d62f2d1f2", "ID": 2831, --- } ] }

But at the same time I think that if the get rows v2 is able to give something else than the two correct options below, then any other query is likely to do the same. The whole issue might be a result of the setup using a gateway.

Was this reply helpful? Yes No
MichelH 401 on at

Like (0)

Report

It doesn't make any sense to me.
There has to be a way to force it, to either produce an error message, or give an array.

Was this reply helpful? Yes No