Answered

Update Property Unavailable

(1) Share

Report

Posted on by RR-09101717-0

We use the Update property in a lot of internal forms to combine hour and minute time values to the date users select in a date picker.

I just discovered this property is no longer available for data cards created for time columns in SharePoint.

Is there another way to add hours and minutes to the selection of a date picker so the total value can be added to (or edited in) a SharePoint list? We are using Power Apps Integrated Forms in SharePoint lists and using modern form controls.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

11manish 3,768 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. The removal of the Update property from modern Power Apps controls (especially in SharePoint-integrated forms) is a known change. With the newer controls, Microsoft has moved away from allowing developers to directly manipulate the value through the Update property.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,182 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @RR-09101717-0,

I have seen a couple of posts on this and it seems to be a version bug, although I cannot duplicate it here. Microsoft have not advertised any change and it seems very strange considering this is fundamentally a low-code app.

So to your issue - this workaround (it should not be necessary) will work

Insert another data card from another field (a Text field will do) and delete everything out of it and ignore the errors

Change the DataField to the name of your date/time field in quotes "MyDateTimeField"

Cut the four controls from your date/time card (date, hour, minute and the : seperator) from the date/time data card into the new card

Now put this (using your control names) in the Update of the new card

DatePickerName.SelectedDate + Time( Value(HourDDName.Selected.Value), Value(MinuteDDName.Selected.Value), 0 )

When you delete the old data card, you will have a couple of errors on the Y values of the controls - just fix them to whatever you need.

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Haque 3,955 on at

Like
a
(2)

Report
Copy link

Link copied!
@RR-09101717-0,

A combination of DatePicker and HourDropdown [0-23] , Minute[0-59] dropdown can address this stuff using DateAdd or Time function. We need to combine the date and time using the DateAdd or Time function.

In the Update property of the data card (or in Patch formula), we can use:

//--Using DateAdd function: Notify(DateAdd( DatePicker1.SelectedDate, Value(HourDrpDown.Selected.Value), TimeUnit.Hours) + Time(0,Value(MinuteDropDown.Selected.Value),0), NotificationType.Information); //--Using Time function Notify( DatePicker1.SelectedDate + Time( Value(HourDrpDown.Selected.Value), Value(MinuteDropDown.Selected.Value),0 ),NotificationType.Information) //--Note: I used Notify function just to test the valid format.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

1 people found this reply helpful.

Was this reply helpful? Yes No
RR-09101717-0 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz, this worked perfectly - I did have to create a work around in SharePoint list to move the resulting value to a true date and time column, but all is working in my flows.

~~One other question - is it possible to add validation requiring the 2nd date/time value to be after the 1st?~~

EDIT: I found a way to validate that end date and time is AFTER the start date and time, and this is also working too.

Thanks,

Ricky

Was this reply helpful? Yes No