Delay Sending Emails Each by 1 day

[protas]

Hello Community,

I am still new to flow and trying to get my way there. Can someone please help with what I am trying to achieve? I would like to create a very basic flow – where 3 emails are sent (Test 1, Test 2, Test 3) and each one is delayed by 1 day.

Any help will be much appreciated.

Thanks,

Eunar

[Expiscornovus]

Hi @protas,

You could add a delay action between the send an email actions. Below is an example of that.

[protas]

@Expiscornovus  Thank you for your quick response Sir. So, if I have a sharepoint or an excel file containing three email addresses, how does my flow know which email addresses to send to at a certain given day?

Thanks.

[Expiscornovus · Accepted solution]

Hi @protas,

Probably the best way to do that is to use an apply to each. But it also depends a bit on how you are storing your e-mail addresses. 

Below is an example which is using a SharePoint list. In this example I am only sending an e-mail to the people from 1 list item btw.

In that list I have created a person or group column called SendTo. This column is configured to allow multiple people values (with email addresses).

1. Add a Get Item action to retrieve this single list item

2. Add a send email action and use the SendTo Email field of the previous action. This will create an apply to each

3. Add a delay action right after the send email action which is still within the apply to each and configure set the time to 1 day.

[protas]

@Expiscornovus Thank you so much for helping me out. I did follow your suggestions. But I always end up getting this when I ran the tests.

Please advise.

Thanks/

[Expiscornovus]

Hi @protas,

Can you share a couple of screenshots of your current setup of your flow?

[protas]

@Expiscornovus I was able to fix it by adding Expression after Get Item

Thanks for the help as always.