Answered

Patch date and time Picker collection (offline) to SharePoint list (datetime format)

(0) Share

Report

Posted on by tg42q15f

Hi,

My App works in offline mode. One of the forms has a picker date (date and time in separated fields) and stores in a temp Collection. When it's sync with server (internet connection) I'm trying to Patch coltempDate and coltempTime to SharePoint list (the single datetime field), but it's not working.

I tried lots of formats but it just store properly in SP if I Patch only the date: Patch(ListSP, {}, { 'Visit Date': DateValue(coltempDate) }.

What I need is to Patch this Colletion field "coltempDate" + "coltempTime" in SP datetime field.

Any help, pls?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Sunil-Narnaware 681 on at

Like
a
(1)

Report
Copy link

Link copied!

@tg42q15f how are you capturing the values of date & time in coltempDate & coltempTime? and what is rationale behind using two separate collections?

Also you should be seeing an error DateValue(coltempDate) as it expects text value and not the table value..? can you check this as well?
tg42q15f 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Suni ,
In the "Save button" of the forms, I pick the date and time as follow:
Collect(colTemp, { tempDtVisita: DateValueDtVisita.SelectedDate, // date from datePicker
tempHrVisita: HourValueHrVisita.SelectedText, // hour from timePicker
tempHrMiVisita: MinuteValueMiVisita.SelectedText // minute from timePicker
}
Then I save it locally (SaveData function) and Load when there's connection. In the synch button I'm trying to get those temp items and Patch to the SP list which has the 'Visit Date' Datetime type. At this point, I only able to send the date without the hour and minute...
Verified answer

tg42q15f 30 on at

Like
a
(1)

Report
Copy link

Link copied!

Now I realized the mistake... in the first Patch (get data from the PickerDate field) I shouldn't have separeted Date collection item from hour colletion item... I did the following inside the Patch:
tempDtVisita: DateValueDtVisita.SelectedDate + Time( Value(HourValueHrVisita.Selected.Value),
Value(HourValueHrVisita.Selected.Value), 0)
Now, in the Patch to sync all the data I just used SP_item: tempDtVisita, and worked perfeclty!
By the way... I was trying to complicate the simple :))
Thank you man!