Skip to main content

Notifications

Power Automate - General Discussion
Answered

Email based on future date in sharepoint list

(0) ShareShare
ReportReport
Posted on by

Hello everyone, i a new to powerautomate, i have an event list with a future event date, i would like to send email alert on the morning of the date of the event

 

not sure how i could do this, or if there is a template i could use.

 

thank you in advance for any help you can provide.

  • vandam2 Profile Picture
    vandam2 on at
    Re: Email based on future date in sharepoint list

    Couldn't get the the formatdatetime to work but the substring did work 

     

    substring(item()?['StartDate'],0,10)
  • vandam2 Profile Picture
    vandam2 on at
    Re: Email based on future date in sharepoint list

    Hello Levi, if my date is 'Start Date' column, what should i use for the formula,

     

    formatDateTime(items('Apply_to_each')?['Start Date'], 'yyyy-MM-dd')
     
    i tried this but get error 
     
    i get this error when i run the test 
    InvalidTemplate. Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.
  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Email based on future date in sharepoint list

    Hi @vandam2

     

    You can create a flow that starts every morning at a fixed time.
    Create a condition to determine whether the date column is equal to today's date and send a reminder email if it exists.

    vliweimsft_0-1669950259068.png

     

    Best Regards,

    Levi

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard