Create a flow for a SharePoint list to send a mail at a calculated date.

[BonCurry]

Hey there! My name is Leon, im a student pretty new to Power Automate, PowerApps, SharePoint etc. In fact im just for a couple of days in touch with all of that stuff.

My Question/Problem:

I have a SharePoint list to maintain the scientific publications of any employee of my company. Therefor the list contains several columns i.e. the authors name, the deparment the employee is working for an so on. One of the columns is named CfP (call for Paper) which is a column vor dates. It represents a deadline an for that sake i want to create a flow which accesses the list to evaluate wether the actual date is 14 days before the date of the CfP-column or not. If so, the flow would send a reminding massage to the author.

For example: Today is january the first in 2024 and i create a new item for my list. That item gots the value 01/27/2024 for the CfP-column. Now i want to recive a massage at 01/13/2024 to remind me to make my paper public.

For now im trying to get used to expressions, because i think that is just what i need. My Approach is to create a automated flow with the constraint to only get triggered once the deadline is 14 days ahead. But i really does not know how to built the expression i need.

I apologize for any grammar mistakes i may had make. Im native german speaker, so english isnt my first tongue. And pls dont roast me for my Subject. As i mentioned, im just in touch with all that stuff for about 2 days know. So dump questions may appear, but im willing to learn. 

I wish you all the best and i hope together we can figure this problem out

[creativeopinion · Accepted solution]

@BonCurry

You might find my tutorial helpful: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays

📅 Project Due Dates

📅 Contract/Membership Renewals

📅 License Expirations

📅 Client Anniversaries

---

IN THIS VIDEO:

✅ How to Send an Email based on a Date Column in SharePoint

✅ Using the Recurrence Trigger in Power Automate

✅How to Use the Filter Array Action with multiple conditions

✅ How to Get Dynamic Content from a Filter Array Action

✅How to Get a Date Three Days from Today

✅ How to Create a Dynamic Date Based on utcNow()

✅ How to Return a Count of Items

✅ How to initialize and set a variable

✅ How to use the Send an Email (V2) action

✅ How to send test emails

In addition to that tutorial, this YT Tutorial might also be of use to you: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok