Hi @andjelamiha97 ,
To create a flow for the above automation, here are the steps:
//Complete flow:
Step 1. Add a "Recurrence" trigger and configure it to run Daily at specific time.
The above trigger is configured to run every day at 09:00 Indian Standard Time (UTC+05:30). Please adjust is according to your specific needs.
Step 2. Then, get all the items from that SharePoint List using the "Get items" Action and add a filter query to check and filter the Specific records where Start date of travel or/and End date of Travel is equals to today's date.
//Filter Query:
Currently, I am checking If either of the "Start Date of Travel" or "End Date of Travel" is equals to Today's date. Here is the expression:
Startdateoftravel eq '@{formatDateTime(utcNow(), 'yyyy-MM-dd')}' or EnddateofTravel eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
If you want to check for both Start Date of Travel and End Date of Travel, use below expressions instead:
Startdateoftravel eq '@{formatDateTime(utcNow(), 'yyyy-MM-dd')}' and EnddateofTravel eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'
*** Paste any of these expressions in the Filter Query of Get items and please make sure to change the name of SharePoint columns if not same.
** utcNow() function is used in the expression to get Current Date and time (when flow runs). It returns date and time both.
*formatDateTime function is used to format the DateTime of utcNow() function to get the Date only.
Step 3. Add an apply to each that iterates of the Values of "Get items" and add a Send an email (V2) Action to send the email.
* In the body of send an email Action, I am currently sending the ID and link to item. But please change this accordingly to your specific requirements.
// SharePoint List and Items:
Below is my test SharePoint list with Start date of travel and End date of Travel columns. Both are of Type - Date and Time (Date only).
//Output:
Received email.
Note: If the flow finds more than one item in the lists where today's date is matched. It will send more emails.
So, Number of emails received = Number of items matched.
Please try it at your end and let me know if you face any issues.
-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.
Thank you,
Harsh Deol
