Unanswered

send an email only if filter array has rows

(0) Share

Report

Posted on by rowan_preston

I have a long winded flow that has a branch after a select function, which then has 2 filter arrays to ultimately produce an email (or emails) for the result of the array. ie we have some product returned and I need to send an email to one person if it's a credit, and an email to a different person if we need to order a replacement. Sometimes a person may return more than one product and a mix of replacement and credits within the return!!!

With the current flow, i am getting an email for both, regardless of whether there is a result in the filter array (just the email has no product listed). I have tried a condition of equals null but no luck...... Any help greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!
This would do the trick:

empty(body('Filter_array'))

equals false

Was this reply helpful? Yes No
rowan_preston on at

Like (0)

Report
Copy link

Link copied!

Thanks for your suggestion. Did I enter it in correctly? It didn't work unfortunately.... The array that contained a result had no input from the condition and so terminated.

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!

@rowan_preston My bad, the right part of the condition should be true (so when empty the flow terminates, if there is smth in the array send the email) in your case, I'm used to having the happy flow in the Yes part of conditions.

Was this reply helpful? Yes No
rowan_preston on at

Like (0)

Report
Copy link

Link copied!

Hmmm this time i got cancelled for the left side, and the right side went to terminate.....

But my left side filter array definitely has "body". aarrrrgghh - I can't figure this out!!

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!

The 'true' in the right side of the comparisson should be entered in the expression editor to make it a real boolean, right now it's a text value.

See below image for how I have this working in many of my flows. (use true in stead of false in your case). Make sure true shows up as a purple field to make sure the editor picked it up ok.

Was this reply helpful? Yes No
rowan_preston on at

Like (0)

Report
Copy link

Link copied!

I really appreciate your help. I changed the expression, and it works when there is a null result, but it doesn't work for a false result - ie when there is body! Just still says no input and cancels the flow on that side.

Was this reply helpful? Yes No