Power App - 12 Hour Formatting

(1) Share

Report

Posted on by DHall-1

I have a Leave Request Power App connected to a sharepoint list. I want the Power App to show the time option in 12 hour format instead of 24 hour.

I added a drop-down for AM & PM option. Default is showing

If(Hour(Parent.Default)<12,"AM","PM")
 
Hour Default drop down option is showing:Text(If(Mod(Hour(Parent.Default),12)=0,12,Mod(Hour(Parent.Default),12)),"[$-en-US]00")
 
HOur Items Option is showing: ["12","01","02","03","04","05","06","07","08","09","10","11"]
 
I have tried to updated the Date Started to reflect the AM & PM option.The Micorosoft List dates(both start & end) will show both dates as AM or PM.
 
This is the current setting for "Update" on my data card
If(Not IsBlank(DateValue2.SelectedDate), DateTime(Year(DateValue2.SelectedDate), Month(DateValue2.SelectedDate), Day(DateValue2.SelectedDate), 
Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi DHall-1

Using your drop-down name, try this
If( !IsBlank(DateValue2.SelectedDate), DateTime( Year(DateValue2.SelectedDate), Month(DateValue2.SelectedDate), Day(DateValue2.SelectedDate), Value(HourValue2.Selected.Value) + If( AMPMDropdown.Selected.Value = "PM", 12 ), Value(MinuteValue2.Selected.Value), 0 ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
DHall-1 18 on at

Like (1)

Report

That worked. Thank you so much

Was this reply helpful? Yes No
Suggested answer

CU22111957-0 2 on at

Like (0)

Report
Just wanted to post this. Thanks @WarrenBlez for your post. It worked for me, but I found a bug where it doesn’t handle the special case for 12 AM correctly.

If( !IsBlank(StartDateValue.SelectedDate), DateTime( Year(StartDateValue.SelectedDate), Month(StartDateValue.SelectedDate), Day(StartDateValue.SelectedDate), If( StartHourValue.Selected.Value = 12, If(StartAMPM.Selected.Value = "AM", 0, 12), Value(StartHourValue.Selected.Value) + If(StartAMPM.Selected.Value = "PM", 12, 0) ), Value(StartMinuteValue.Selected.Value), 0 ) )

This formula checks if the selected hour is 12 and adjusts accordingly:

If it’s 12 AM, it sets the hour to 0.

If it’s 12 PM, it keeps the hour as 12.

For other hours, it adds 12 if it’s PM.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

My blog on this is here if that helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
SpoTechGeek 63 on at

Like (0)

Report

My post here could help you out: Configuring Date Picker in AM/PM Format

Was this reply helpful? Yes No