Send an email to the email address on the same row when a cell is updated

[Ezza]

Hi

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?

Many thanks

[fchopo]

Hi @Ezza 

Can you share your workflow so we can provide more detailed help?

Ferran

[Ezza]

[Ezza]

I've added my workflow, thank you.

[fchopo]

Hi @Ezza 

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!

Ferran

[Ezza]

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?

Many thanks

[fchopo]

items('apply_to_each')?['Closed Date'] is not equal to null

 Hope it helps!

Ferran

[Ezza]

I have tried what you've advised but it's still sending it to all the email addresses under the Requester email column.

[fchopo]

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).

[Ezza]

Sorry, I'm not sure what you mean by that

[fchopo]

I mean you can see the output values and check date closed values:

[Ezza]

I've provided the outputs but I cannot see it on the trail

[Ezza]

Just letting you know that I changed the following for confidential purposes:

• Email address - changed as 'Email'
• Location - changed as 'Site/Building'

[fchopo]

OK! I see that empty dates come as "", so a comparison with null value should work.

Please, review the condition again.

Ferran

[Ezza]

I've already tried it but it's still sending it to all the email addresses

[Ezza]

Is there anything I need to change for the action send an email?

[fchopo]

Try using this formula in the if condition:

empty(items('Apply_to_each')?['Date Closed']) is not equal to bool('True'))

 Ferran

[Ezza]

Sorry, not sure how to put that on the condition. Do you mind sending a screenshot please?

[fchopo]

Left condition: 

empty(items('Apply_to_each')?['Date Closed'])

Operator: is equal to

Right Condition: bool('True')

---

[Ezza]

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?