Patching Date and Time

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I collect a date from a DatePicker and minute/hour from dropdowns as follows:

CommencedTime: DPDate1.SelectedDate & (DDHourValueBC.Selected.Value & "." & (DDMinuteValueBC.Selected.Value)),

works fine but when I go to try patch it back to the SP list (datetime field) I'm running into problems..

Commenced:DateValue(CommencedTime)

saying it doesn't recognise it as a date/time value

I've tried numerous variation of the above also. My problem is that the date I need is in one Date picker and the hours and minutes are in separate DropDowns. If I leave out the Datepicker all together and just try to patch back the results from the drop down those work fine for the hours/minutes but obviously the date is wrong... Have also tried DateTimeValue( infront.

any suggestions. Should I be collecting the full date and time at the collection level or only when I go to patch it back? because the date field is used on it's own anyway in the collection..

TIA

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Adam1986 139 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vffdd,
If you look what is in Update property of Form DataCard for date and time column you can see that it is formated like this.
DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)
Mayby you should build your custom date and time picker like Form DataCard for date and time column.
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks @Adam1986 but it's not a form so no update
Verified answer

Adam1986 139 on at

Like
a
(1)

Report
Copy link

Link copied!
@vffdd
I know this is not form and there is no Update property. But this is what you should Patch.
This is solution for your approach.
Just patch as follows:

Patch( Adam_test, { DateStart: DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 ) } )
Adam1986 139 on at

Like
a
(1)

Report
Copy link

Link copied!

Remember that date and time is actually a number so your approach with '&' is incorrect. You need to add date to hours and minutes to calculate single column date and time value.
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

ok I'll remove the & so and play around with it. Unfortunately I can't use your approach as I have to use the date that has been added to the collection. Reason being this app is used offline as well as on and the patch may not take place till a day later so the date picked from the drop down won't be valid. The collection is saved to a local file after collected and then that populates the collection next time app starts.. so I have to use the date that was collected !
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@vffdd it's clear that @Adam1986 was referring to the way you are constructing the date, not the patching itself.

You said yourself that you collect dates like this:

CommencedTime: DPDate1.SelectedDate & (DDHourValueBC.Selected.Value & "." & (DDMinuteValueBC.Selected.Value)),

So instead now you will collect them like this:

CommencedTime: DPDate1.SelectedDate + Time(Value(DDHourValueBC.Selected.Value), Value(DDMinuteValueBC.Selected.Value), 0),
Adam1986 139 on at

Like
a
(0)

Report
Copy link

Link copied!
@vffdd, then collect and store this date-time value as number in your local file.

Value( DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 ) )

then just Patch that value to sharepoint. I dont see any issue with this solution. If u got correct date and time as value you can collect or patch it like you want.
Like this below, outcome will be the same.

Patch( Adam_test, { DateStart: 1683687840000 } )
Adam1986 139 on at

Like
a
(1)

Report
Copy link

Link copied!

@vffdd , @iAm_ManCat is right,
I see that i should be more specific. I suggested approach to get, collect, patch value that represents your date time value. What you need to do with it is your decision. There is many options how you can handle this solution.
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

ok great thanks for your help, let me play around with that and see if I can get it to work 🙂