cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GuyBoswell
Advocate II
Advocate II

Convert UTCNow() to local time

I need to add a date time to a report in local UK time based on time now.

 

UTCNow() gives me time now.  Convert time zone allows me to convert either to GMT (which happens to be the same as UTC) or to GMT+1 (which is the same as BST).

 

I have found plenty of posts  that explain that but how do I get it to convert to local time, i.e. either GMT or BST as appropriate depending on which is in force at the time?  I can't select based on date because it doesn't change on the same date every year - it always changes on a Sunday.

 

For international friends GMT - Greenwich Mean Time is the time used in the UK during the winter, BST - British Summer Time is used in the summer.  You might know it as daylight saving time.

 

More than happy with an answer that says if you want to get there I wouldn't start from here 😉 - as long as it does actually get me there!

 

Thank you very much for your help.  Guy

7 REPLIES 7
v-alzhan-msft
Community Support
Community Support

Hi @GuyBoswell ,

 

Does the Convert time zone works on your said to achieve the requirement?

Could you please explain more details about the requirement? If you share an example of the expected time type in UK from the utc time, I would better understand you and provide the proper workaround for you.

 

I suggest that you should know how many hours earlier or late between the utc time and your local UK time, then you could add or delete the hours from the utc time to get the local time.

 

Best Regards,

Alice

 

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

VictorIvanidze
Memorable Member
Memorable Member

Hi @GuyBoswell,

 

assuming your Office 365 profile contains proper time zone you can retrieve it to provide the further time conversion.

Unfortunately to get TimeZone value you have to invoke a GRAPH request GET https://graph.microsoft.com/v1.0/me/MailboxSettings  , that requires to use a Premium action "Invoke a HTTP request".

Hi Alice,

In the UK we are either UTC+0 or UTC+1, depending whether daylight saving is in effect.

The convert time zone step only seems to work with a fixed differential.

Thank you for your help.

Guy

Hi Victor,

Premium actions are not an option - we cannot get them with our charity account.

Is there really no way to read system time directly?  It seems very strange.

Thank you for your help.

Guy

Hi @GuyBoswell, unfortunately I do not know a way to "read system time directly" without premium action.

It might be someone else knows?

Hi again @GuyBoswell,

 

as an alternative you can try to use a custom connector:

https://docs.microsoft.com/en-us/graph/tutorials/power-automate 

JamesMoyle
Frequent Visitor

I had the same problem but I think they may have changed the function of the Convert Time Zone widget. It now gives the option on UTC +0 London which seems to take account of BST. It certainly works for me anyway!

 

JamesMoyle_0-1630614310629.png

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,254)