Unanswered

Validating Boolean value with condition fails

(0) Share

Report

Posted on by mdruedal

Hi all,

I am building a flow where I am checking in my SQL database if a row is present or not, and I am having issues getting the Condition to state True.

If the Row is present in the SQL table, it should go to the "left" part of the condition (YES).

Here is my flow :

The left part in the Condition - Equals is right now this:

equals(outputs('Execute_a_SQL_query_(V2)_check_for_already_existing_row')?['body/resultsets/Table1'], bool(1))

Here is the result from the SQL query :

And the result from the Condition:

Can anyone point me in the right direction to what I am doing wrong ??

I am grateful of any help I can get 😄

/Michael

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

VictorIvanidze 13,058 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

Hi @mdruedal,

simplify a bit. Place to the left part this:
outputs('Execute_a_SQL_query_(V2)_check_for_already_existing_row')?['body/resultsets/Table1']

Was this reply helpful? Yes No
mdruedal 15 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

Thanks for the suggestion, however this has the same result, The SQL query result is "true" but the result of the condition is "false"

Was this reply helpful? Yes No
VictorIvanidze 13,058 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

Try to use string true instead of function in the right part.

Was this reply helpful? Yes No
mdruedal 15 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

still the same result :

Was this reply helpful? Yes No
mdruedal 15 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

And Btw. this is my SQL Query :
SELECT CASE WHEN EXISTS (SELECT 1 FROM [dbo].[XYZ] WITH (NOLOCK) WHERE DATE='4-5-2021') THEN CAST (1 AS BIT) ELSE CAST (0 AS BIT) END

I think this would result in a Boolean value, or am I mistaken ?

Was this reply helpful? Yes No
Verified answer

mdruedal 15 on at

Like (0)

Report

Re: Validating Boolean value with condition fails

Ok, I Solved my problem by taking another approach and counting the rows instead, converting the count to an integer and then in the condition: if greater than 0 the row exists and the flow will terminate.

Was this reply helpful? Yes No