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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do I Trigger Power...
Power Automate
Unanswered

How do I Trigger Power Automate flow from a SharePoint list using a Date column once a specified amount of time has passed, based on a pending condition?

(0) ShareShare
ReportReport
Posted on by

Hello - I'm very new to Power Automate, so apologies if this is a simple question. I have researched but have been unable to find an answer!

 

How do I trigger a power Automate flow from a SharePoint List using a date when a certain amount of time has passed?

 

Basically, I want to trigger a flow send an email if a record in the List is marked as 'Pending' and 5 days has passed since the created date. If the record is marked as 'Complete', no action is to be taken.

 

Would there also be a way for the flow to add to the record in the List to say a reminder email has been sent?

 

Thank you in advance! 🙂

Categories:
I have the same question (0)
  • mrocha_23 Profile Picture
    2 on at

    Hi,

    You could use a Scheduled Flow to run daily and get the items that meet your conditions.

    mrocha_23_1-1718136467649.png

    Here's the formula for the date:

    addDays(utcNow(),-5,'yyyy-MM-dd')
     
    From there you can create a table using the 'Create an HTML Table' Action and send it via email using the outlook connector 'Send an email (v2)'

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard