ADF IF Activity Expression Question?

Question

@Nasreen Akter @MartinJaffer-MSFT @KranthiPakala-MSFT

For an IF Activity I have @equals(item().isFullTime,true) for the Expression. It doesn't seem to be working.

Do I need to use @equals(item().isFullTime, 'true') (with single apostrophe)? In the JSON we have

isFullTime":false or isFullTime":true

Thanks!
Mike

Answer 1

Hi @Mike Kiser

Thank you for posting your query.

If your json return values in Boolean that means as true or false then it will work in equals function.

In below example, My Lookup activity getting "isFullTime" property value in Boolean and I am using that property in IF activity with equals() function to compare with true. Its working fine for me. Kindly check below steps of implementation

Step1: Lookup activity getting data from SQL table

Step2: Passing Value array from lookup activity to ForEach activity

Step3: If Activity Inside ForEach Loop

Step4: If we observe execution. My pipeline is executing Activity which is inside True of IF condition. Hence, its shows that if your property value has Booleans such as true or false then you can use directly below expression to compare.
@equals(item().isFullTime,true)

Hope this will help. Please let us know if any further queries. Thank you

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications.