Answered

Time zone conversion issue

(0) Share

Report

Posted on by PremierD

Hi PA community,

Seeking knowledge and help please. I have a flow that is working. When a change is made to a file in a folder in SharePoint it triggers an email, happy days. However the 'modified time' is skewed and always an hour ahead. Can anyone point out where I am going wrong or where to change? Flow and formulas below

formatDateTime(addDays(utcNow(),-7))

convertTimeZone(item()?['Modified'],'UTC','W. Europe Standard Time','f')

And in the email the 'modified' time that uses the convert time zone is always one hour ahead, how can I make it match GMT?

email example.png

Thanks in advance 🙂

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@PremierD In you screenshot, HTML Table action, I see

Instead of the Expression, can you give the action below a try...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
PremierD 54 on at

Like (0)

Report
Copy link

Link copied!

Hi CFernandes,
I am not entirely sure where in the flow to place it? As I cannot place it in the HTML table area, should it be just before?
Thanks

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @PremierD,

I think the issue that the converted time zone is always one hour ahead is caused by daylight saving time, as a workaround, you just need to do is use addHours() function to adjust, place it in the HTML table area:

addHours(convertTimeZone(item()?['Modified'],'UTC','W. Europe Standard Time','f'),1,'f')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
PremierD 54 on at

Like (0)

Report
Copy link

Link copied!

Hey Lin_Tu

That really helped, I had to change the hours to '-1' , and then it was spot on, thanks very much.

Was this reply helpful? Yes No
Clifferton 94 on at

Like (0)

Report
Copy link

Link copied!

did the flow remain correct after daylight savings time changed again?

Was this reply helpful? Yes No