Terminate Flow when no data meets condition

[gardnerlhwrc]

Hi All,

So I have all my flows set up nicely. Just noticed something so I have the following set up. 

Flow basically looks for due date tomorrow and then send an email (using filter query).

What I've noticed is that it sends an email even if there is no data.

How can I make it go that little extra mile and it doesn't proceed if there isn't any data. I've tried using a control but then it adds an 'Apply to each' which then results in an email getting sent for each item with the HTML table

Thanks L

[KvB1]

You could implement a condition that checks whether the value of the get items action has a length of greater than 0

[fchopo · Accepted solution]

Hi @gardnerlhwrc 

You can get the number of items of the SharePoint "Get items" action, and if it's bigger than 0, then proceed to send the email.

So, to get the number of items you would use the following expression:

length(body('get_items')?['value'])

And use it inside a condition (bigger than 0) just before the select action (and put all the other actions inside the "yes" branch).

Hope it helps!

Ferran

[gardnerlhwrc]

Amazing thank you all.