Add a condition to avoid empty email

[sajarac]

Hello community. 

I am looking for some help with my flow.

I have a two share point list

1. Employees

2. Orders

In my list Orders I have a Date column "ETD"

In my flow I am filtering the Employees first to get only the people that I need. For instance Emp by Department = Production

 

Now in my second list I am filtering based in the following

Employee Name "LC_Initials eq 'Outputs' and ETD ge 'Today' and ETC le 'Today + 2 days.

The employees selected can get the email with the ETD that falls into this criteria. for instance 5 employees 

I need to send an email to each employee when the ETD y equal to today + 2 days. The 5 employees are getting the email but 2 of them doesn't have a date for the ETD. I mean:

5 Employees are receiving the email notification. 3 employees with the ETD in the email body and 2 employees with the email body empty.

My question is:

How can I implement a condition to avoid sending an empty email? If the employee doesn't have any ETD date that matches the criteria is not receiving an email.

Thanks in advance for any help.

Regards

[WillPage · Accepted solution]

The get items within the Apply to each loop returns no items you want no email to go to that person? If that's the case, then simply add a condition like length(body('Get_items_OCL10plus2')?['value]) is greater than 0 and put the email action in the yes branch.

[sajarac]

Thank you very much Sr. Fixed at the first attempt.

Very appreciated 

🙂