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)

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report
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 12,966 Super User 2025 Season 2 on at

Like (0)

Report

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

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 12,966 Super User 2025 Season 2 on at

Like (0)

Report

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