Answered

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)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

this is the output:

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

it's works ! Thanks !

Was this reply helpful? Yes No
Vanessa_0612 30 on at

Like (0)

Report
Copy link

Link copied!

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
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

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