You’re offline. This is a read only version of the page.
28
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?
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.
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.'.
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.
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.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
