ADF and @Equal Expression

Question

Hello
I have the following values in the DB as a bit datatype
[grandfatheredPension] [bit] NULL,

When I do an ADF Lookup I get the following:
for the grandfatheredPension value

THEN, I use an IF Condition and have the IF Activity Expression as

MY ISSUE is that the value stored as a 1 in the grandfatheredPension field in the DB NEVER Drops in the True Activity of the If Condition. I have tried everything that I can think of.

Can you please assist?
Thanks!
Mike

@Nasreen Akter @MartinJaffer-MSFT

Answer 1

Hi @Mike Kiser ,

The equation you have i.e., @equals(item().grandfatheredPension, true) looks good to me. In your pipeline if you have a LOOKUP then FOREACH and then IF, it should work. From your description you did not mention about a for-loop. would you please clarify. Thanks!