I am trying to create a flow where, when a cell is updated with a date (Date Closed column), it will then send an email to the email address under the 'Requester email' column of the same row (screenshot below).
So far, the flow I've created sends it to all the email addresses under the Requester email column.
Please can you help?
Can you share your workflow so we can provide more detailed help?
When using "List rows present in a table" excel action, please, use set DateTimeFormat to ISO 8601
If not, excel dates are returned like integer numbers (although I don't understand why condition is always true).
Hope it helps!
Thank you for the advice.
Do you have any idea how I can setup the condition and send an email so it only sends an email to the email address under the 'Requester email' column of the same row when a date has been entered on the Date Closed column?
items('apply_to_each')?['Closed Date'] is not equal to null
Hope it helps!
You can also try with
empty(items('apply_to_each')?['Closed Date']) is equal to true
Could you share the output of the list rows actions in excel where the row has no value (so we can see the output and tackle the problem).
I mean you can see the output values and check date closed values:
Just letting you know that I changed the following for confidential purposes:
OK! I see that empty dates come as "", so a comparison with null value should work.
Please, review the condition again.
Try using this formula in the if condition:
empty(items('Apply_to_each')?['Date Closed']) is not equal to bool('True'))
Operator: is equal to
Thank you, that worked. However, when I entered random dates on the other cells on the 'Date Closed' columns, it sent out an email for each of those cells.
What formula can I put so even if other cells have a date on them, it only sends it to, for example, the one that had the date today?