Skip to main content

Notifications

Power Automate - Using Flows
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

  • dylandavis09 Profile Picture
    dylandavis09 438 on at
    Re: Update items automatically every 15 mins

    @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
    Inogic 901 on at
    Re: Update items automatically every 15 mins

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics

Restore a deleted flow