Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

Sending an email based on middle date between two dates

(0) ShareShare
ReportReport
Posted on by 1

Hi all 🙂

 

I'm looking to send an email at the middle point of two dates that are stored within a Sharepoint list.  I had set up the middle date as a calculated field within the Sharepoint List however I have now found out that I can't create a flow based on a calculated field.  

 

Is there a way to build into my Power Automate that it will take the start date and end date and find the middle date and trigger an email on the middle date?  

 

Im a newbie so any help is appreciated 🙂

 

Thanks

  • AnthonyAmador Profile Picture
    AnthonyAmador 2,519 on at
    Re: Sending an email based on middle date between two dates

    Hi @eilidh3 

     

    Here is a really good community blog talks about how to do that.

    How to find the number of days between two dates u... - Power Platform Community (microsoft.com)

     

    You can do that, then divide the days by two and use the addDays() expression to add the number of days to the date. 

     

    Hope this can help you. 

    Cheers. 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics

Restore a deleted flow