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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Automatically Change S...
Power Automate - Building Flows
Unanswered

Automatically Change Status based on date and time

(1) ShareShare
ReportReport
Posted on by dylandavis09 438

I want to automatically manage the status of 'OPEN' and 'CLOSED' based on the current date and time relative to specified start and end dates and times. The status should be 'CLOSED' until the start date and time, after which it will be 'OPEN' until the end date and time. Once the end date and time are reached, the status will revert to 'CLOSED'. 
 

If either the start date or end date is left blank, then the system should not monitor or update the status for opening or closing. Until I inputing in.

 

Categories:
Business Process Flows
Flow Mobile App
Licensing
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 68,324 Most Valuable Professional on at
    Automatically Change Status based on date and time
    The easiest way to do this is create a flow to run nightly that reads the list, Checks the Start Date and End Date to see if the Current Date is between them.  If it is then set the status to Open, otherwise set the status to Closed.  There is no way to create the status column so it will automatically change related to date. It has to be changed by an external process.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans