Unanswered

Condition with connector "run a query against a dataset PowerBI"

(0) Share

Report

Posted on by Vanessa_0612

Hello All,

I try to make a condition with my result in my connector run a query against a dataset PowerBI, but doens't work ...
One idea?

Thanks !

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Vanessa_0612

Pls try using expression for the left part of the condition. Expression needs to be added in the expression box as shown below:

first(outputs('Run_a_query_against_a_dataset')?['body/firstTableRows'])?['CountALERT_CHECK']

EDIT (Revised Expression):

first(outputs('Run_a_query_against_a_dataset')?['body/firstTableRows'])?['[CountALERT_CHECK]']

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Vanessa_0612 30 on at

Like (0)

Report

Hello,

Thanks for you help, I have a result "FALSE" in the output I have 4 ...

Was this reply helpful? Yes No
Vanessa_0612 30 on at

Like (0)

Report

this is the output:

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Vanessa_0612

Apologies, there was a typo in the expression. I have updated the expression in my original reply.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Verified answer

Vanessa_0612 30 on at

Like (0)

Report

it's works ! Thanks !

Was this reply helpful? Yes No
Vanessa_0612 30 on at

Like (0)

Report

One question, is work only with is egal to, it's possible to have a formula for use " is greater than" 0 ?

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Yes, you could select the operator to "greater than" from the drop down & set 0 on the right side of the condition.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No