HI All,
What happened to the complex conditions in FLOW?
All I have now is the basic with an add button to add more basic conditions!
I create flows for when items are created or modified.
I use a condition where modified = created for new items. (And of course I have to convert to my timezone)
then I use complex conditions where I test for empty columns to send send out update alerts.
I can have 5 or more alerts sent in one FLOW.
--New items go to a group
--updated items go to another group when some column is updated
--updated items go to other groups based on other updated columns. ...
I tried to use the new basic "where sent to is not equal to" and I left the criteria blank, but that didnt work. it sent even when the column was blank.
then I tried where not equal to '' also failed like leaving empty!
Can someone please tell me how to do the below in the new basic condition?
@and(not(empty(triggerBody()?['DateSent'])),not(empty(triggerBody()?['DateSentToTax'])),empty(triggerBody()?['DateSentTo']),empty(triggerBody()?['DateReviewedByTaxDept']))
Thanks,
Joe
Solved! Go to Solution.
Hi @joef
I went over the announcement made by the Flow team yesterday about the new Condition builder, and in it, they explain how to build a complex condition to check if values are empty, etc. Here's how I tested the new approach on my end:
empty(triggerBody()?['DateSent'])For the logical operator, select is not equal to, and the value on the right, go to the Expressions tab again and type true. You can continue the same approach for the remaining fields the condition needs to check. Here's a screenshot of my final condition with the same fields used in your expression:
I hope these instructions point you in the right direction. Please, do not hesitate to reach out if you have any questions.
Regards,
Fausto Capellan, Jr
Hi @joef
I went over the announcement made by the Flow team yesterday about the new Condition builder, and in it, they explain how to build a complex condition to check if values are empty, etc. Here's how I tested the new approach on my end:
empty(triggerBody()?['DateSent'])For the logical operator, select is not equal to, and the value on the right, go to the Expressions tab again and type true. You can continue the same approach for the remaining fields the condition needs to check. Here's a screenshot of my final condition with the same fields used in your expression:
I hope these instructions point you in the right direction. Please, do not hesitate to reach out if you have any questions.
Regards,
Fausto Capellan, Jr
You're welcome!!!
Need some help. None of these suggestions are working for me.
expression I'm using
Not allowing to continue flow
Hi @LarryAlx
What happens if you add that Condition below the Query for Salesforce Records? The Condition should check outside the Apply to each loop you have there. Question: what's in value the Apply to each is looping through?
Thanks!!!
I really appreciate your response and after I posted my question, I spent the whole evening trying to figure it out and finally got it working. I believe I actually ended up doing exactly what you said. I was checking the body within an apply to each, when I took it out, things started flowing.
Flowing
It's Working!!!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
31 | |
30 | |
24 | |
24 | |
21 |
User | Count |
---|---|
64 | |
57 | |
43 | |
37 | |
29 |