Default hour to now if form mode new but don’t change if edit

Like (0) Share

Report

Posted on 8 Nov 2023 22:07:11 by Jimbobrich

Hi,

I have a power app form linked to SharePoint list. One of the cards Is a date and time picker.

i have managed to set the date to current date if the form is new but use parent default if editing.

what I would like to achieve is to set the hour and mins to current time if the form is in new mode, however if the form is in edit I would just like the previously selected values to remain.

time format would need to be 24 hour.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

gcmfaizan 1,022 on 09 Nov 2023 at 13:48:41

Like (1)

Report
Re: Default hour to now if form mode new but don’t change if edit

@Jimbobrich
On DatePicker DefaultDate use this:
If( Form1.Mode = FormMode.New, DateTimeValue(Text(Today(), "yyyy-mm-dd")), Parent.Default )
On Hours Dropdown Default property use:
If( Form1.Mode = FormMode.New, Hour(Now()), Text(Hour(Parent.Default),"00") )
and On Minitues Dropdown Default property use:
If( Form1.Mode = FormMode.New, Minute(Now()), Text(Minute(Parent.Default),"00") )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No