Answered

Power Apps Working with Time and Time zones

Like (0) Share

Report

Posted on 24 May 2024 02:43:51 by jmccune1

Hello,

I am building into my app a screen that allows my instructors to schedule a class time. My instructors teach in all 4 times zones, so I would like them to be able to select a time for the class in their time zone and it show all 4 based on their selection. I currently have 4 drop downs, 1 for the hours and 1 for the mins by :15 mins. They would then select their time zone and the chart next to it would show the class for each of the zones. Is this possible? I have been researching time, but I am not exactly sure how to use it in Power apps. Will time work with text? Or does it need to be a number? Any help you can provide would be amazing.

Categories:

General Questions

All responses (3)

Answers (1)

jmccune1 on 24 May 2024 at 04:13:04

Like (0)

Report

Re: Power Apps Working with Time and Time zones

🙂
jmccune1 on 24 May 2024 at 03:31:24

Like (0)

Report

Re: Power Apps Working with Time and Time zones

It worked, thank you so much!
Verified answer

v-yueyun-msft on 24 May 2024 at 03:12:22

Like (0)

Report

Re: Power Apps Working with Time and Time zones

Hi , @jmccune1

I test it in my side :

Pacific Standard Time (UTC-08:00) Pacific Time (US and Canada)
Central Standard Time (UTC-06:00) Central Time (US and Canada)
Montevideo Standard Time (UTC-03:00) Montevideo
Eastern Standard Time (UTC-05:00) Eastern Time (US and Canada)

I use this expression in Label-Text:
With({SelcetedTime:TimeValue(Dropdown1.Selected.Value & ":" &Dropdown2.Selected.Value & " "&Dropdown3.Selected.Value ) },
Switch(Dropdown4.Selected.Value,
"Pacific Standard Time" ,$"Class Time:{ DateAdd(SelcetedTime , 8-5 ,TimeUnit.Hours ) } EST {Char(10)} { DateAdd(SelcetedTime , 8-6 ,TimeUnit.Hours ) } CST{Char(10)}{ DateAdd(SelcetedTime , 8-3 ,TimeUnit.Hours ) } MST{Char(10)}{ DateAdd(SelcetedTime , 8-8 ,TimeUnit.Hours ) }PST" ,
"Central Standard Time", $"Class Time:{ DateAdd(SelcetedTime , 6-5 ,TimeUnit.Hours ) } EST {Char(10)} { DateAdd(SelcetedTime , 6-6 ,TimeUnit.Hours ) } CST{Char(10)}{ DateAdd(SelcetedTime , 6-3 ,TimeUnit.Hours ) } MST{Char(10)}{ DateAdd(SelcetedTime , 6-8 ,TimeUnit.Hours ) }PST" ,
"Montevideo Standard Time" , $"Class Time:{ DateAdd(SelcetedTime , 3-5 ,TimeUnit.Hours ) } EST {Char(10)} { DateAdd(SelcetedTime , 3-6 ,TimeUnit.Hours ) } CST{Char(10)}{ DateAdd(SelcetedTime , 3-3 ,TimeUnit.Hours ) } MST{Char(10)}{ DateAdd(SelcetedTime , 3-8 ,TimeUnit.Hours ) }PST" ,
"Eastern Standard Time",$"Class Time:{ DateAdd(SelcetedTime , 5-5 ,TimeUnit.Hours ) } EST {Char(10)} { DateAdd(SelcetedTime , 5-6 ,TimeUnit.Hours ) } CST{Char(10)}{ DateAdd(SelcetedTime , 5-3 ,TimeUnit.Hours ) } MST{Char(10)}{ DateAdd(SelcetedTime , 5-8 ,TimeUnit.Hours ) }PST" ) )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang