Unable to get SQL database results.

(0) Share

Report

Posted on by soooofunny

127

Hi, All.

I'm having trouble with how to retrieve SQL execution results in SQL Database.
The results obtained with PowerAutomate are as follows.

It cannot be obtained even with a function such as "variable('ARRAY VARIABLE NAME')[0]".
I want to get only "0" from the result as below, what should I do?

Thanks.

[
{
"": 0
}
]

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-LilyW-msft on at

Like (1)

Report

Re: Unable to get SQL database results.

Hi @soooofunny

Please try this expression:

variables('Test')?[0]?['']

Hope the content above may help you.

Best Regards

If my replay helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

soooofunny 127 on at

Like (0)

Report

Re: Unable to get SQL database results.

I'm sorry for my late reply.
I was able to achieve it by what you taught me.
Thanks!

Was this reply helpful? Yes No