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.
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com