web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Convert 24h time to ne...
Power Apps
Unanswered

Convert 24h time to new time based on UTCTime Time Zone selection

(0) ShareShare
ReportReport
Posted on by 67

Hi,

 

I thought I had this working, but I guess not. Now I'm banging my head 🤕 with no resolve. Maybe someone can help.

 

Situation/Problem: My Powerapp is an Event Registration app where the user selects an Event (from SP ListA), goes to a TimeZoneScreen screen and selects their local Time Zone from a dropdown (TimeZoneGallery), and she then clicks the Next button to navigate to the final RegisterConfirmScreen. The RegisterConfirmScreen has a basic ViewForm of the Event details, but is required to have the user selected/updated local Time Zone on which to base what I write to SP ListB.

 

The Need: The Event selected (left inset image) needs to be converted to the users local TimeZone selection choice from the TimeZoneScreen (center inset image) and be displayed correctly as shown below in the custom card value fields of StartTimeValue and TimeZoneValue (right inset image) in the RegisterConfirmScreen.

2021-08-30_14-48-41.png

 

 

Any ideas?

@v-xida-msft  @WarrenBelz 

 

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    Hi @GigaenvyTAG69 ,

    You need the TimeZoneOffset function which returns the difference between the user's device and UTC.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • GigaenvyTAG69 Profile Picture
    67 on at

    Ok, I got the Time Zone conversion working. That was easy.

     

    Can someone help with how to convert a SP List 'Start Time' text column record (in 24h time) to the new time when a user selects a Time Zone from a Gallery?

     

    Example 1:

    If SP column 'Start Time' is 10:00 (based on UTC-6:00) and the user selected their time zone from TimeZone Gallery.item (UTC-5:00) Eastern Time (US and Canada), how can I show a text label of the converted time to 11:00?

     

    Example 2:

    If SP column 'Start Time' is 11:00 (based on UTC-3:00) and the user selected their time zone from TimeZone Gallery.item (UTC+9:00) Osaka,Saporro, Tokyo, how can I show a text label of the converted time to 23:00?

     

    The Time Zone Gallery item selections from a SP List choice column are formatted as follows:

     

    (UTC-12:00) International Date Line West
    (UTC-11:00) Coordinated Universal Time -11
    (UTC-10:00) Hawaii
    (UTC-09:00) Alaska
    (UTC-08:00) Pacific Time (US and Canada)
    (UTC-08:00) Baja California
    (UTC-07:00) Mountain Time (US and Canada)
    (UTC-07:00) Chihuahua, La Paz, Mazatlan
    (UTC-07:00) Arizona
    (UTC-06:00) Saskatchewan
    (UTC-06:00) Central America
    (UTC-06:00) Central Time (US and Canada)
    (UTC-06:00) Guadalajara, Mexico City, Monterrey
    (UTC-05:00) Eastern Time (US and Canada)
    (UTC-05:00) Bogota, Lima, Quito
    (UTC-05:00) Indiana (East)
    (UTC-04:30) Caracas
    (UTC-04:00) Atlantic Time (Canada)
    (UTC-04:00) Cuiaba
    (UTC-04:00) Santiago
    (UTC-04:00) Georgetown, La Paz, Manaus, San Juan
    (UTC-04:00) Asuncion
    (UTC-03:30) Newfoundland
    (UTC-03:00) Brasilia
    (UTC-03:00) Greenland
    (UTC-03:00) Montevideo
    (UTC-03:00) Cayenne, Fortaleza
    (UTC-03:00) Buenos Aires
    (UTC-02:00) Mid-Atlantic
    (UTC-02:00) Coordinated Universal Time -02
    (UTC-01:00) Azores
    (UTC-01:00) Cabo Verde Is.
    (UTC) Dublin, Edinburgh, Lisbon, London
    (UTC) Monrovia, Reykjavik
    (UTC) Casablanca
    (UTC) Coordinated Universal Time
    (UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
    (UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb
    (UTC+01:00) Brussels, Copenhagen, Madrid, Paris
    (UTC+01:00) West Central Africa
    (UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
    (UTC+01:00) Windhoek
    (UTC+02:00) Minsk
    (UTC+02:00) Cairo
    (UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
    (UTC+02:00) Athens, Bucharest
    (UTC+02:00) Jerusalem
    (UTC+02:00) Amman
    (UTC+02:00) Beirut
    (UTC+02:00) Harare, Pretoria
    (UTC+02:00) Damascus
    (UTC+02:00) Istanbul
    (UTC+03:00) Kuwait, Riyadh
    (UTC+03:00) Baghdad
    (UTC+03:00) Nairobi
    (UTC+03:00) Kaliningrad
    (UTC+03:30) Tehran
    (UTC+04:00) Moscow, St. Petersburg, Volgograd
    (UTC+04:00) Abu Dhabi, Muscat
    (UTC+04:00) Baku
    (UTC+04:00) Yerevan
    (UTC+04:00) Tbilisi
    (UTC+04:00) Port Louis
    (UTC+04:30) Kabul
    (UTC+05:00) Tashkent
    (UTC+05:00) Islamabad, Karachi
    (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
    (UTC+05:30) Sri Jayawardenepura
    (UTC+05:45) Kathmandu
    (UTC+06:00) Ekaterinburg
    (UTC+06:00) Astana
    (UTC+06:00) Dhaka
    (UTC+06:30) Yangon (Rangoon)
    (UTC+07:00) Novosibirsk
    (UTC+07:00) Bangkok, Hanoi, Jakarta
    (UTC+08:00) Krasnoyarsk
    (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi
    (UTC+08:00) Kuala Lumpur, Singapore
    (UTC+08:00) Taipei
    (UTC+08:00) Perth
    (UTC+08:00) Ulaanbaatar
    (UTC+09:00) Irkutsk
    (UTC+09:00) Seoul
    (UTC+09:00) Osaka, Sapporo, Tokyo
    (UTC+09:30) Darwin
    (UTC+09:30) Adelaide
    (UTC+10:00) Yakutsk
    (UTC+10:00) Canberra, Melbourne, Sydney
    (UTC+10:00) Brisbane
    (UTC+10:00) Hobart
    (UTC+10:00) Guam, Port Moresby
    (UTC+11:00) Vladivostok
    (UTC+11:00) Solomon Is., New Caledonia
    (UTC+12:00) Magadan
    (UTC+12:00) Fiji
    (UTC+12:00) Auckland, Wellington
    (UTC+12:00) Coordinated Universal Time +12
    (UTC+13:00) Nuku'alofa
    (UTC-11:00) Samoa

     

  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    @GigaenvyTAG69 ,

    With difficulty - would require some dissection, conversion to number, add a value, then put back to Text. 

  • GigaenvyTAG69 Profile Picture
    67 on at

    @WarrenBelz @I have it figured out with Power Automate and works like a dream and writes the lookup as well back to SPO from the form.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard