Answered

Get Items Timezone Query

(0) Share

Report

Posted on by ccqn

205

Hi all, I would like to send an email at 7am SGT (UTC+8) containing details of SP items created the day before. The timezone of my SP site is also as SGT. Can I check if the below query would work correctly to fetch the entries?

Created lt '@{addhours(utcNow('yyyy-MM-dd'),8)}' and Created ge '@{adddays(addhours(utcNow(),8),-1,'yyyy-MM-dd')}'

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

lbendlin 8,367 Super User 2025 Season 2 on at

Like (0)

Report

Get Items Timezone Query

Please define what you mean by "the day before" - in SGT or in UTC?

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Get Items Timezone Query

The day before in SGT

Was this reply helpful? Yes No
Verified answer

Mark Nanneman 989 Super User 2025 Season 2 on at

Like (0)

Report

Get Items Timezone Query

Why even bother with the timezone conversion? Is there a reason you can't just pull items created more than 24 hours ago?

i.e. Created ge @{addHours(utcNow(),-24)}

If you need to do the time zone thing, you can do it like this with actions in power automate:

Then reference the "Converted Time Zone" property from the "Convert Time Zone" action in your filter query:

If you're comfortable with formulas, you can skip the actions and do it all in a formula like:
addHours(convertTimeZone(utcNow(),'UTC','Central Standard Time'),-24)

Another method to accomplish processes like this is to filter on a column that you update for each item that's included in your report or email. It could be a date field, a boolean or a choice set--whatever you want! Just filter on the items that haven't been updated (i.e. "sentInEmail ne true" or "dateEmail eq null") then just use any existing For Each loop to update the appropriate filter columns on the SP items, or add a new For Each loop to the end of the flow to do it.

Hope that makes sense or helps!

Was this reply helpful? Yes No