Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How can I create a flow to send reminder emails from a List based on a project's check frequency?

(1) ShareShare
ReportReport
Posted on by
 

I want to set up a Power Automate flow that sends reminder emails for projects listed in a SharePoint list. Each project has a "Start Date" and a "Check Frequency (Days)" column. The flow should calculate if the current date falls on a day when a reminder is due based on the frequency value and then send an email to the responsible person listed for the project.

I have been using the Get Items function and it outputs the values that I want however when I try to use this as the input to a For Each loop it says the expression is invalid. I have also attached a photo of the current SharePoint List setup.

Are there any common pitfalls to watch out for when building these sort of flows?

Any help would be greatly appreciated.

  • trice602 Profile Picture
    trice602 11,627 on at
    How can I create a flow to send reminder emails from a List based on a project's check frequency?
    Hi,
     
    I like this approach, check this out!
     
    StartDate le 'utcNow()'
     
    Add a compose NextReminderDate
     
    addDays(items('Apply_to_each')?['StartDate'], items('Apply_to_each')?['CheckFrequency(Days)'])
     
     
    Add a condition
     
    formatDateTime(outputs('NextReminderDate'), 'yyyy-MM-dd') eq utcNow('yyyy-MM-dd')
     
     
     
    You may need to convert your timezone if you run into issues.
     
    convertFromUtc(utcNow(), 'Pacific Standard Time', 'yyyy-MM-dd')
     
     

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

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard