Unanswered

Value Condition, Created Time and Limits for Completing Actions

(0) Share

Report

Posted on by jamescosten

643

I have a need for a flow to check a SP column value and depending on this value set a time constraint that can then trigger a condition. Easier if I show an example.

If the Value is AM then the created time of the Item in SP needs to be before 08:00am else another action. If the item was created before 08:00 on that day then no other action required.

This is for facility checks needing to be conducted within an hour of their shift time.

My column is a choice and i have 5 selections, each with their own times.

0700 AM

0800 OFFICE

0830 FACILITY 1

1500 PM

2300 NIGHTS.

Any idea how I could put this into a flow? I can put parralel branches with Conditions for each area, but how would I set the condition of the time?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

David_MA 14,347 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
I would use the formatDateTime function to format just the hours of the Created date in 24-hour format and convert it to an int:

int(formatDateTime(triggerOutputs()?['body/Created'],'HH'))

You could use the expression in a condition to check if the result is less than or greater than 8 depending on which side of the condition you want to proceed. I am not sure how the five choices relate to the need to check if the time is before 8 a.m. though.

Was this reply helpful? Yes No
David_MA 14,347 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

P.S. don't forget that SharePoint stores dates in UTC format, so you may need to convert the created date/time to another time zone first and use the expression on the converted date.

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Annoyingly I will also need to account for DST also. Assuming there is a way to take this into account in the UK?

Was this reply helpful? Yes No
David_MA 14,347 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

From my understanding, when you convert a time zone in Power Automate and specify the source and destination time zones, it takes into account daylight savings time and adjusts accordingly. I never did any testing on this, but nobody has complained to me about it yet. 🙂

Was this reply helpful? Yes No