Unanswered

Calendar of events showing wrong time after time change

(0) Share

Report

Posted on by LWhit

Hi all

I have a flow that gets, among other things, daily calendar items and puts them into a HTML table then emails it. After the clocks have changed recently, the time is one hour out on the events. I've tried converting the timezone but then I'm not sure how to get this into the table instead of the original times. Does anybody have a solution to this?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @LWhit ,

I suggest you use "convertFromUtc" in "Create html table" to convert time, instead of using "Convert time zone" control.
You could refer to the following link:
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Best regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
LWhit 28 on at

Like (0)

Report

Thanks, I've taken a look at that but unsure how to get start time into that? The example includes a static time so unsure how to make that work

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @LWhit ,

According to your picture, it may be convertFromUtc(item()?['Start time'], 'time zone name')

Best regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
LWhit 28 on at

Like (0)

Report

Hmm, still no luck. I've tried what you have suggested and convertTimeZone(item()?['Start time'], 'GMT Standard Time', 'W. Europe Standard Time', 't')

Time changes just have to mess it up!

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @LWhit ,
Is there any error message?

Was this reply helpful? Yes No
LWhit 28 on at

Like (0)

Report

Hi, yeah there is, seen below. It's been the same for both ways - saying that there's NULL. To confirm, there are calendar items that it should be returning, as just using the basic start time returns them but with the incorrect time

The execution of template action 'Create_HTML_table_2' failed. The column values could not be evaluated: 'The template language function 'convertTimeZone' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.

Was this reply helpful? Yes No
Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report
Hi @LWhit ,
Try this:
convertTimeZone(item()?['start'], 'GMT Standard Time', 'W. Europe Standard Time', 't')
convertTimeZone(item()?['end'], 'GMT Standard Time', 'W. Europe Standard Time', 't')

Best regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No