web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How can I create a flo...
Power Automate
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.

Screenshot 2025-01-16 120831.png
Categories:
I have the same question (0)
  • trice602 Profile Picture
    16,164 Super User 2026 Season 1 on at
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 641

#2
Vish WR Profile Picture

Vish WR 640

#3
Haque Profile Picture

Haque 495

Last 30 days Overall leaderboard