Share via

Create email alert from list based on a date

Carly Carper 21 Reputation points
2022-07-15T20:34:47.49+00:00

I am trying to create an email alert based on an answer/date in a column in my list. What I want to do is have a date and then have it generate an email alert 8 days after the date that was chosen. I want the email to send to the person who added the item to the list.

Microsoft 365 and Office | SharePoint Server | For business
0 comments
Accepted answer
  1. Yanli Jiang - MSFT 31,611 Reputation points Microsoft External Staff
    2022-07-18T14:23:23.25+00:00

    Hi @Carly Carper ，
    Your requirements can be implemented using Power automate.
    The list used in the test is as follows:
    221818-07182.png

    Create a new flow: choose “Scheduled cloud flow” and set the parameters according to your actual situation.
    221890-07183.png

    Fill in the judgment conditions:

    formatDateTime(item()['Created'],'yyyy-MM-dd')
    is equal to
    addDays(utcNow(),-8,'yyyy-MM-dd')

    NOTE: Created is the column that records the time when the item was created. You can also change it to other date and time type columns.
    221860-07184.png

    Then run the flow and you can receive an email as below:
    221911-07185.png

    Thanks,
    Yanli Jiang

    ===========================================

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 57,831 Reputation points Volunteer Moderator
    2022-07-15T22:17:38.763+00:00

    Hello @Carly Carper

    This will require a SharePoint List and PowerAutomate.

    1) Create a flow in PowerAutomate

    2) Choose "Schedule" > "Recurrence" > Interval 1 Day

    221286-image.png

    2) Set up Get My Profile V2 as second step:

    221276-image.png

    3) Setup SharePoint "Get Items" > Enter formula for "Filter Query" (formula from https://powerusers.microsoft.com/t5/Building-Flows/How-to-create-a-flow-that-will-send-an-email-60-days-after-data/td-p/828884) as seen below: 

    Created ge '@{formatDateTime(adddays(utcNow(),-8),'yyyy-MM-dd')}T00:00:00' and Created le '@{formatDateTime(adddays(utcNow(),-8),'yyyy-MM-dd')}T23:59:59'

    221298-image.png

    -8 is a representation for 8 days ago. This can be change to whatever you want for days.

    4) Add new action > Send an email (V2) > Add dynamic content > Created by Email

    Then customize your message and body to your liking. You can add different dynamic content into the Subject and Body from the list as well.

    Once you are done adding the information for Send an email (V2) > Hit Save

    221277-image.png

    ----------------------------------

    Hope this helps! If you find it helpful please mark as correct answer.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.