How to patch date and time from date and time picker

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am trying to patch a date and time to SP List from the date and time picker of my power apps form.

My current formula only patches the date but not the time.

Patch(
 'Walkdown Requests_1',
 Defaults('Walkdown Requests_1'),
 {
 'Proposed Date & Time':DateValue1.SelectedDate
 }
 )

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (3)

Report
Hi @Anonymous ,

Assuming the control names below

Patch( 'Walkdown Requests_1', Defaults('Walkdown Requests_1'), { 'Proposed Date & Time': DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.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.

Was this reply helpful? Yes No
natng 5 on at

Like (0)

Report
Hi there,

I tried the solution method provided, while the rest of my fields patched through, my DateValue still does not change on Sharepoint. What seems to be the problem?

Patch(RequestTicket, LookUp(RequestTicket, RequestID=Text(RequestHistoryLog_Gallery.Selected.RequestID)), { CollectionDateTime:DateValue(DateValue2.SelectedDate + Time(Value(HourValue2.SelectedText.Value), Value(MinuteValue2.SelectedText.Value),0), ShortDate), CollectorName:Text(DataCardValue47), 'CollectorContactNo.':Value(DataCardValue48.Text), Remarks:Text(DataCardValue40) });

Thank you.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (3)

Report
@natng ,

You had some extra bits in there not in the post below

Patch( RequestTicket, LookUp( RequestTicket, RequestID = Text(RequestHistoryLog_Gallery.Selected.RequestID) ), { CollectionDateTime: DateValue2.SelectedDate + Time( Value(HourValue2.SelectedText.Value), Value(MinuteValue2.SelectedText.Value), 0 ), CollectorName: Text(DataCardValue47), 'CollectorContactNo.': Value(DataCardValue48.Text), Remarks: Text(DataCardValue40) } );

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No