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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update items automatic...
Power Automate
Unanswered

Update items automatically every 15 mins

(0) ShareShare
ReportReport
Posted on by dylandavis09 438

I'm having trouble setting up an automated flow in SharePoint to update values every 15 minutes, ensuring that all items whose 'Start: Date/Time' and 'End: Date/Time' fields match the current time transition from 'OPEN' to 'CLOSED' appropriately. For example, if an event like 'Registration Classes' starts on May 31 at 12:00AM and ends on May 31 at 12:15AM, it should remain 'OPEN' until 12:15AM, when it transitions to 'CLOSED', reflecting the current Eastern Standard Time (EST).


Screenshot 2024-05-30 at 1.21.31 AM.pngScreenshot 2024-05-30 at 1.19.34 AM.png

Categories:
Using flows
I have the same question (0)
  • Inogic Profile Picture
    Inogic 1,196 Moderator on at

    Hi,

     

    As per our understanding, you're looking to transition the status to 'Closed' when the 'End: Date/Time' matches or is earlier than the current time.

    So first you need to get items which have 'End: Date/Time' less than or equal to current date and Status equals to Open.

    You can try with the filter query is as follows to get items that are Open and EndDate is older than the current time:

     

    EndDateTime i.e. '@{formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ', 'UTC')}'  and  Status eq 'Open'

     

    then you can add a step to update Status of item to the 'Closed'.  

     

    Inogic_0-1717068470468.png

     

    We have tried the same and able to get the items with condition and change the status to Closed for retrieved records.

     

    Hope this helps.

     

    Thanks!

    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com
    Service: https://www.inogic.com/services/
    Tips and Tricks: https://www.inogic.com/blog/
  • dylandavis09 Profile Picture
    dylandavis09 438 on at

    @Inogic, I've been attempting to use your suggested filter query, but unfortunately, it's still not functioning as expected. Thus, I'd like to implement a solution based on the current time.

     

    For example, let's consider the scenario where, as of May 30 at 5:00 PM, an event titled 'Add and Drop Classes' has been added. Its start date/time is set for May 30 at 5:30 PM, and its end date/time is May 30 at 5:45 PM. Presently, the status is 'CLOSED', and it should automatically transition to 'OPEN' when it reaches 5:30 PM. This transition should occur seamlessly since the flow is already configured to update every 15 minutes.

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

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 February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans