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
