I was creating a flow to update event based on my MS form responses. The flow retrieves the training date and time picked by the person who submitted the form and update it in calendar accordingly. Everything works fine but there is only one issue...
After receiving a response, the flow automatically converts my time for that event into UTC time zone. Although I can manually convert the time back to my time zone in my mind but it is very confusing, especially for my trainees. For example:
The timing it is still correct after converting to UTC+8 but is there any method for it to show my desired time zone, instead of having to go through the trouble of manually converting the time zone?
Attached below are some screenshots of my flow:
Here are the outputs:
Does anyone possibly know the reason behind this issue and solution to this?
You could accomplish this a few ways.
Simplest would be to add a "Convert Time Zone" Step and adjust the time zone. Use the result for your email.
Or you could use the Function: Converttimezone / ConvertFromUtc
- convertFromUtc(outputs('UTC_Date'),'India Standard Time','g')
- convertTimeZone(outputs('IST'),'India Standard Time','Pacific Standard Time','g')
Thanks for the suggestion. May I know where should I add the convert time zone step?
I tried adding it between Get event and Update event but it didn't work:
Or maybe it is in the right place but the input to this "Convert Time Zone" is not valid?
Any idea how can I fix this?
You can do one thing initialize timezone in starting of the flow and use in respective actions as needed.
for ex in get event you're using time
formatDateTime(convertFromUtc(Utcnow(),'Pacific Standard Time','g'))
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.