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.

Column	Column Type
Title	Single line of text
Assigned To	Person
Start Date	Date and Time
End Date	Date and Time
Status	Choice
Delivered?	Yes/No
Budget	Currency
Comment	Multi-line of Text

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.

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.

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())'

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.

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.

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.

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

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

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

Related Power Automate tutorials:

• Power Automate or Microsoft Flow check day of week
• Power Automate SharePoint Get Items Filter Query
• Power Automate send email to SharePoint group
• Power Automate remove characters from a string
• Power Automate Array Variable
• Power Automate send email based on form response
• How to create a word document from a template in Power Automate

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