cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anonymous2022
Regular Visitor

CONVERT FROM UTC TO LOCALTIME

Hello,

 

hope someone can help me I've been trying to resolve conversion but seems it is not flowing correctly,

I can already convert time format from UTC to local, however when I am trying to convert for 'response date' using expression this dynamic content is no longer visible, I tried hard coding the formula changing body as 'response Date' but it says it is invalid content. Basically I'll need to get time of each response to see whether who among the approvers approved late, all is working fine already except for the UTC format of time which I am having a hard time converting, thank you!

 

 

anonymous2022_0-1634530847404.png

anonymous2022_1-1634531027598.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
CFernandes
Super User
Super User

Hey @anonymous2022 

 

You can use  - 

 

CFernandes_0-1634540563367.png

 

 "convertTimeZone" expression:

convertTimeZone(utcNow(),'UTC','Romance Standard Time')

Reference - https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones

 

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!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

View solution in original post

3 REPLIES 3
CFernandes
Super User
Super User

Hey @anonymous2022 

 

You can use  - 

 

CFernandes_0-1634540563367.png

 

 "convertTimeZone" expression:

convertTimeZone(utcNow(),'UTC','Romance Standard Time')

Reference - https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones

 

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!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

View solution in original post

anonymous2022
Regular Visitor

thank you!😉

@anonymous2022 I am glad that my inputs helped 😊

 

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!

 

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,466)