Time Picker AM/PM Hour and Minute

(0) Share

Report

Posted on by MH3

1,057

Hello, Everyone

I am using SharePoint Data-source and I want to have a Date Picker with Time Hour and Minute along with AM and PM Selector,

so what I did is this:

I changed the minute value picker into AM/PM selector, but I need Hour, Minute and AM/PM Auto Selected as per current time

Update Formula:

DateValue4_2.SelectedDate + Time(If(MinuteValue4_2.Selected.Value = "PM", 12, 0) + Mod(Value(HourValue4_2.Selected.Value), 12), 0, 0)

I need the Minute picker as well and the Hour Minute and AM/PM should auto pick by default as respect to the current time.

Need help for adding minute value.

Any Help

Categories:

Building Power Apps

I have the same question (0)

All responses (25)

Answers (2)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

HI @MH3 ,
The complete code for 12 hour AM/PM time is on this post of mine. Happy to assist further if you get stuck.

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.

Was this reply helpful? Yes No
v-siky-msft on at

Like (2)

Report

Hi @MH3 ,

I suggest you add a new Request Date DataCard in the form and remove the older one, since it's clearer to start from scratch.

Please try the following steps:

1. create a Timer, Set Duration:1000, Enable Repeat and Auto start, Disable Auto pause, Set OnTimerStart: Set(VarCurrent,Now())

2. unlock the data card, add a dropdown in it, rename to AmPmValue1,

set Items: ["AM","PM"]

set Default: If(Hour(VarCurrent) < 12, "AM", "PM")

3. modify property of HourValue:

Items: ["12","01","02","03","04","05","06","07","08","09","10","11"]

Default: Text(If(Mod(Hour(VarCurrent), 12) = 0, 12, Mod(Hour(VarCurrent), 12)),"[$-en-US]00")

4. modify property of MinuteValue:

Default: Text(Minute(VarCurrent),"[$-en-US]00")

5. Modify property of data card:

Update: DateValue1.SelectedDate + Time(If(AmPmValue1.Selected.Value = "PM", 12, 0) + Mod(Value(HourValue1.Selected.Value), 12), Value(MinuteValue1.Selected.Value), 0)

Hope this helps.

Sik

Was this reply helpful? Yes No
MH3 1,057 on at

Like (0)

Report

Hello @WarrenBelz ,

I have done what you have said in your post and it's working fine, but I want to set the current time when the user creates a new record and in edit mode it should display the time which I had selected while creating.

can you tell me what will be the code?

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

Like (1)

Report

Hi @MH3 ,
You can default the date/time to Now().

Was this reply helpful? Yes No
MH3 1,057 on at

Like (0)

Report
Sir @WarrenBelz
actually I want to make the Date picker card values to the current by default when creating a new record;
example: 16/06/2020 01:50 PM (my Current Time and Date) and when editing the existing record it should display the previous values,

what I have in the default of the card is this:

Card Default Property:
ThisItem.RequestDate

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

Like (1)

Report
Hi @MH3 ,
Try
If( YourFormName.Mode = FormMode.New, Now(), ThisItem.RequestDate )

Was this reply helpful? Yes No
MH3 1,057 on at

Like (0)

Report
Hi @WarrenBelz

I put this code before your code:
If(ReqFrom.Mode=FormMode.Edit,ThisItem.RequestDate,Now())

what's the difference between yours and this?

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

Like (0)

Report

HI @MH3 ,
In yours, it would show the current time in View Mode (that is if you ever switch to this)

Was this reply helpful? Yes No
MH3 1,057 on at

Like (0)

Report

Hi @WarrenBelz

I think it's not working, I have created a record with date and time:

and when I open the record in Edit it shows this:
01:38 PM, although I had selected 01:52 PM (which was by default the Current time when I was creating the record).

Any help in this?

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

Like (1)

Report

Hi @MH3 ,
I just did a test my end with my code and it worked perfectly on a new record.

Was this reply helpful? Yes No