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:

Building flows

All responses (3)

Answers (1)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

The day before in SGT
Verified answer

Mark Nanneman 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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!