Answered

Need help with condition to find empty value

(0) Share

Report

Posted on by Paulcofla

Need a Condition, if the choice Category field equals to Engineer and the lookup column Sponsor field is empty; I want it to follow the YES path but if the Category field equals Engineer and the Sponsor field is not empty then follow the NO path which terminates the flow.

The 1st row of the condition works. I can't get the 2nd row to find/fetch the empty value.

I used the 1st dynamic field below from Get Item group, operator "is equal to" and the expression: equals(triggerOutputs()?['body/LU_x003a__x0020_WO_x003a_Sponsor'],null)

For the 2nd row, should I use the Dynamic field from Get Item or from When Item is Created (the item was created on another flow):

LU: WO:Sponsor
LU: WO:Sponsor Id
LU: WO:Sponsor Value

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Paulcofla

The way you have written the expression is wrong and also the expression content , see below

It should be the way the expression is written

Also try this expression as Sponsor value is always present in value attribute which can be found from trigger output itself.

or(equals(triggerOutputs()?['body/LU_x003a__x0020_WO_x003a_Sponsor']?['Value'],null),empty(triggerOutputs()?['body/LU_x003a__x0020_WO_x003a_Sponsor']?['Value']))

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Paulcofla 15 on at

Like (0)

Report
Copy link

Link copied!

@Nived_Nambiar Thank you so much! this worked perfectly. You are the best!!

Was this reply helpful? Yes No