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 / Update items automatic...
Power Automate
Unanswered

Update items automatically every 15 mins

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • dylandavis09 Profile Picture
    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.

  • Inogic Profile Picture
    1,135 Super User 2025 Season 2 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/

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
David_MA Profile Picture

David_MA 265 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

#3
trice602 Profile Picture

trice602 202 Super User 2025 Season 2

Last 30 days Overall leaderboard