cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ezza
Helper I
Helper I

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

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

 

Ezza_0-1633593814430.png

 

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

 

23 REPLIES 23
fchopo
Super User
Super User

Hi @Ezza 

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

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
Ezza
Helper I
Helper I

Ezza_2-1633599852446.png

Ezza_3-1633599873184.png

 

 

 

I've added my workflow, thank you.

fchopo
Super User
Super User

Hi @Ezza 

When using "List rows present in a table" excel action, please, use set DateTimeFormat to ISO 8601

rows-excel.png

 If not, excel dates are returned like integer numbers (although I don't understand why condition is always true).

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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
Super User
Super User

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

notnull.png

 Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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

fchopo
Super User
Super User

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

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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

fchopo
Super User
Super User

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

excel-table.png

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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

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

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

Ezza_0-1633614495600.png

Ezza_1-1633614527919.png

 

fchopo
Super User
Super User

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

Please, review the condition again.

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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

Ezza_0-1633676826065.png

 

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

Ezza_1-1633677039469.png

 

fchopo
Super User
Super User

Try using this formula in the if condition:

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

 Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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

fchopo
Super User
Super User

Left condition: 

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

Operator: is equal to

 

Right Condition: bool('True')

 


condition.png

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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?

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,425)