Time Picker AM/PM Hour and Minute

[MH3]

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

[WarrenBelz]

Hi @MH3 ,

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

[MH3]

Hi @WarrenBelz ,

Yes, it working good on new record, but the time does not change automatically when I create a new record, like if I open the app in studio and then run the app and go to new screen at that time it shows 3:00 PM which was current time, at 3:05 PM I again go to the create screen it shows 3:00 PM the time which I had started the app in studio mode.

What is this  problem?

[WarrenBelz]

@MH3 

Now() will default to the time you create the record (that is what a Default does). It is not a "running clock".

I cannot test this, but if you put on the Save button - before the SubmitForm

Reset(YourDateControlName)

it should put in the time that it is saved. 

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.

[MH3]

Hi @WarrenBelz ,

actually I have 5 Screens and 5 forms and I am submitting the whole form at the end, by the help of Patch function,

my Submit Button Code:

Reset(MinuteValue_1);

If(RemForm.Mode=FormMode.Edit,
Patch('Travel Request',ReqGal.Selected,ReqFrom.Updates,InfoForm.Updates,TripForm.Updates,PrefForm.Updates,RemForm.Updates), 
Patch('Travel Request',Defaults('Travel Request'),ReqFrom.Updates,InfoForm.Updates,TripForm.Updates,PrefForm.Updates,RemForm.Updates));

Do I have to enter the Reset code before this?

Help

[WarrenBelz]

@MH3 ,'

You are referencing the FormMode as Edit - Is this what you have set the Reset criteria to. If so, yes resetting the Card should put in the current date and time.

I also assume MinuteValue_1 is the name of the Card, not the Minute selector.

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.

[MH3]

Sir @WarrenBelz ,

Acutally, I am submitting all the form data at the end in the last form, and no MinuteValue_1 is the Minute selector,

if I put the DataCard of the Data/time Selector it gives error : expects a control name

Reset(RequestDate_DataCard1_2);
If(RemForm.Mode=FormMode.Edit,
Patch('Travel Request',ReqGal.Selected,ReqFrom.Updates,InfoForm.Updates,TripForm.Updates,PrefForm.Updates,RemForm.Updates), 
Patch('Travel Request',Defaults('Travel Request'),ReqFrom.Updates,InfoForm.Updates,TripForm.Updates,PrefForm.Updates,RemForm.Updates))

help?

[WarrenBelz]

@MH3 ,

You are really getting adventurous to Patch a modified date control. If you go back to the link in my original post, you will see the Update property of the modified card - you should be able to work from that

DateControlName.SelectedDate + 
Time(
   If(
      AmPmControlName.Selected.Value = "PM", 
      12, 
      0
   ) + 
   Mod(
      Value(
         HourControlName.Selected.Value
      ), 
      12
   ), 
   Value(
      MinuteControlName.Selected.Value
   ),
   0
)

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.

[MH3]

Sir @WarrenBelz ,

I saw your post, I just did what you have said in your post and updated my Update Property, according to my requirement, but still the time problem is there..

[WarrenBelz · Accepted solution]

@MH3 ,

What is the error on? Can you please pull this apart until it runs and identify which piece of code is causing the issue.
Also you might try this

Reset(RequestDate_DataCard1_2);
If(
   RemForm.Mode=FormMode.Edit,
   Patch(
      'Travel Request',
      {ID:ReqGal.Selected.ID},
      ReqFrom.Updates,
      InfoForm.Updates,
      TripForm.Updates,
      PrefForm.Updates,
      RemForm.Updates
   ), 
   Patch(
      'Travel Request',
      Defaults('Travel Request'),
      ReqFrom.Updates,
      InfoForm.Updates,
      TripForm.Updates,
      PrefForm.Updates,
      RemForm.Updates
   )
)

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.

[MH3]

Hi @v-siky-msft ,

I have tried your formula, it's working perfect.

but when I edit the record the time picker should display the default selected time when I created the record and should display Current time when creating new record.

how to alter it? can you guide?  for edit and new form?