Add 30 minutes to End Date Time when Start Date Time selected

[hkmamun]

I am saving information to a SharePoint list from PowerApps by an AddForm. In the form there are StartDateTime and EndDateTime fields. I am doing this with a Date Picker control for selecting date and 2 combo box for Hour & Minute. So my requirements are below

1. When the AddForm will be loaded then by default StartDateTime  will show the current date & time and the EndDateTime will show current date & time + 30 minutes.
2. In the AddForm if the user update the StartDateTime  then EndDateTime will be updated by StartDateTime + 30 minutes.

Please help me how I can do the solution.

Thanks!

[mdevaney]

@hkmamun 

Put this code in the Default property of the Start_DateTime field.

Now()

Then use this code in the Default property of the End_DateTime field

DateAdd(Now(), 30, Minutes)

Finally, change the DisplayMode property of End_DateTime so the user can't change this field themselves.

DisplayMode.View

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[hkmamun]

@mdevaney  The PowerApps DatePicker control only gives to select date, so I have used 3 control to select Start date (1 date picker to elect date + 1 combobox to select Hour +1 combobox to select Minute) and same for to select End date (below picture)

 So, Now() will not work in that case, What I did I used Hour() function to set hour and Minute() function to set minute for Start date time, how I will 

1. Set End date by adding 30 minutes to Current time

2. When user will update/change Start Date Time value then need to add 30 minutes to that updated/changed date time value and need to show in End Date time.

I hope my requirements is now clear to you, please inform me if you need more clarification.

Thanks!

[mdevaney · Accepted solution]

@hkmamun 

Put this code in the Default property of the End Date minutes 

Minute(DateAdd(DatePicker_StartDate.SelectedDate+Time(Dropdown_Hours.Selected.Value, Dropdown_Minutes.Selected.Value,0), 30, Minutes))

This goes in the Default property of End Date Hours

Hours(DateAdd(DatePicker_StartDate.SelectedDate+Time(Dropdown_Hours.Selected.Value, Dropdown_Minutes.Selected.Value,0), 30, Minutes))

This goes in the Default property of End Date

DateAdd(DatePicker_StartDate.SelectedDate+Time(Dropdown_Hours.Selected.Value, Dropdown_Minutes.Selected.Value,0), 30, Minutes)

All of the End fields should have their DisplayMode property set to this:

DisplayMode.View

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[hkmamun]

@mdevaney  thanks for your valuable help, but when the user will update the value of Start Date, Hour & Minute that time also need to update the End Date, Hour & Minute based of updated value.

So, how I resolve this solution?

Thanks!

[mdevaney]

@hkmamun 

Did you try my method?  That’s exactly what my solution does.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[hkmamun]

@mdevaney  thanks for your support , it is not working. See my code below

Control Name	Control Type	Event/Property	Code	Value Coming
AddActivityScreen	Screen	OnVisible	UpdateContext({CurrentHour:Text(Hour(Now()),"[$-en-US]00"),CurrentMinute:Text(Minute(Now()),"[$-en-US]00")});
dtpStartDate_1	Date picker	DefaultDate	Now()	6/9/2020
ddlStartHour_1	Combo box	Default	CurrentHour	01
ddlStartMinute_1	Combo box	Default	CurrentMinute	53
dtpEndDate_1	Date picker	DefaultDate	DateAdd(dtpStartDate_1.SelectedDate+Time(Value(ddlStartHour_1.Selected.Value), Value(ddlStartMinute_1.Selected.Value),0), 30, Minutes)	6/9/2020
ddlEndHour	Combo box	Default	Hour(DateAdd(dtpStartDate_1.SelectedDate + Time(Value(ddlStartHour_1.Selected.Value), Value(ddlStartMinute_1.Selected.Value),0), 30, Minutes))	00
ddlEndMinute	Combo box	Default	Minute(DateAdd(dtpStartDate_1.SelectedDate + Time(Value(ddlStartHour_1.Selected.Value), Value(ddlStartMinute_1.Selected.Value),0), 30, Minutes))	23

NOTE: I can not keep the DisplayMode to View of all End Date & Time property, since user can change/select this values also.

Thanks!

[hkmamun · Accepted solution]

@mdevaney thanks for your support your code help me a lot to finalize the solution, I just set below code to the controls Default property. So now if I update the value in StartDate+Hour+Minute then EndDate+Hour+Minute 's value is changing according

1. Start Date control's DefaultDate property

Now()

 2. Start Hour control's Default property

Text(Hour(Now()),"[$-en-US]00")

 3. Start Minute control's Default property

Text(Minute(Now()),"[$-en-US]00")

4. End Date control's DefaultDate property

DateAdd(startDatePicker.SelectedDate+Time(Value(StartHourControl.Selected.Value), Value(StartMinuteMinute.Selected.Value),0), 30, Minutes)

5. End Hour control's Default property

Text(Hour(DateAdd(StartDatePicker.SelectedDate + Time(Value(StartHourControl.Selected.Value), Value(StartMinuteControl.Selected.Value),0), 30, Minutes)),"[$-en-US]00")

6. End Minute control's Default property

Text(Minute(DateAdd(StartDatePicker.SelectedDate + Time(Value(StartHourControl.Selected.Value), Value(StartMinuteControl.Selected.Value),0), 30, Minutes)),"[$-en-US]00")

Thanks!