Microsoft flow send email based on create date

In this Power Automate tutorial, we will discuss how to send an email based on Created Date in Power Automate or Microsoft flow. A detailed example on Microsoft flow send email based on create date.

So, here we will create a Microsoft Flow, that will send an email to the recipient based on the Created Date of the item in the SharePoint list.

Power Automate send an email based on Create date

Here we will see how to send an email to the recipient based on created Date in SharePoint List using Microsoft Flow or Power Automate.

I have created a Project Management list in SharePoint Online, when a new project is added to the list in Sharepoint, the manager will get an email of the Project which are newly added, which means if the created date is equal to today’s date.

For example, if the user creates a project such as ‘SharePoint Migration’ on 10-12-2021 and today’s date is also 10-12-2021, then only the manager will get an email.

If the project is created on 9-12-2021 and today’s date is 10-12-2021, then the flow will not trigger, only the manager will get the email if the created date is equal to today’s date.

Read Power automate split string into an array with examples

Steps for Power Automate send an email based on Create date

Here we will see the steps to send an email based on Create Date using Microsoft Flow.

Step 1: Create a SharePoint List

In SharePoint Online, I have created a SharePoint list called the Project management list having 8 columns with the required column type.

ColumnColumn Type
TitleSingle line of text
Assigned ToPerson
Start DateDate and Time
End DateDate and Time
StatusChoice
Delivered?Yes/No
BudgetCurrency
CommentMulti-line of Text
Project Management list
Power Automate send email based on create date
Power Automate send email based on create date

Once your SharePoint Online list is created, then we will move forward to create a flow in Power Automate.

Step 2: Create a Flow

Now we will create a flow to send an email based on Create Date.

So, Log in to Power Automate, and then click on Create and select Scheduled cloud Flow.

Power Automate send email based on create date
Power Automate send email based on create date

Now provide the flow name, then under ‘Run this Flow’ set the date when the flow will start and then set the frequency as every day. Then click on Create.

microsoft flow send email based on create date
Microsoft flow send email based on create date

Also, check out Microsoft Flow or Power Automate employee onboarding

Step 3: Get items From the SharePoint list

In this step, we will get all items and then filter the item those created dates are equal to Today’s date by using Filter query.

So for this click on the Next step and then select the ‘Get items‘ action. Then provide the site address and list name. Next click on the ‘Show Advanced options’, In Filter query Field write the below expression

Created ge'fx(addDays(utcNow(),-1))' and Created lt'fx(utcNow())'
microsoft flow send email based on create date
Microsoft flow send email based on create date

Step 3: Create an Html table

Now we will create an Html table to send in the email, So, click on The Next step and then select the Create Html table action.

Then in From select value-Get items from the dynamic content. Then click on Show advanced options, in column Field change the Automatic to Custom. Then map the header and value like the below screenshot.

microsoft flow send email based on create date
Microsoft flow send email based on create date

Step 4: Send an Email

Now to send an email, click on the Next step and then select Send an email(V2) action. Then Provide the To, Subject and in Body select the output- Create Html table.

how to send an email based on Created Date using Microsoft Flow
how to send an email based on Created Date using Microsoft Flow

Once your Flow is ready, we can check the Flow Manually.

Step 5: Run the Flow

So our Flow is scheduled to run every day, for text purposes we will run the flow manually.

So I have created two items in the Project Management SharePoint list.

how to send an email based on Created Date using Microsoft Flow
how to send an email based on Created Date using Microsoft Flow

Now click on Save and run the Flow manually, you can see flow ran successfully.

microsoft flow send email based on create date
Microsoft flow send email based on create date

Next check your email, you will get the email in the outlook based on Created date.

microsoft flow send email based on create date
Microsoft flow send email based on create date

This is how to send an email based on created date using Microsoft Flow.

Related Power Automate tutorials:

In this Power Automate tutorial, we learned how to send an email based on Created Date using Microsoft Flow.

>