Answered

Patching date and time field to a SharePoint list

(0) Share

Report

Posted on by ekoz21

Hi all,

I have a form in PowerApps with a data source of SharePoint. The date fields have type of date and time in a SharePoint. I am collecting entries into a collection and then I want to save them back to a SharePoint list.

I have tried to use the following formula to save date and time inside the Patch formula:

StartOfFootage: DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), Value("00"))

However, once saved I get the following outcome in SharePoint:

Any ideas how can I patch date and time from a collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ekoz21 ,

Try this

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
ekoz21 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, the formula that you provided works perfectly when adding date and time into a collection, however, it returns today's date when patching.

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ekoz21 ,

Very strange as you are referring to the value in a Date Picker - it cannot "invent" today's date as you would need to refer to Today() or Now() in the formula.

Can you please post (in Text) the exact formula of your Patch.

Was this reply helpful? Yes No
ekoz21 66 on at

Like
a
(0)

Report
Copy link

Link copied!

    Patch(
    VideoRecordings,
    Defaults(
        VideoRecordings
        ),
    {
        NumOfCamera: NumOfCamera_lbl.Text,
        StartOfFootage: DateValue1.SelectedDate +
        Time(
            Value(HourValue1.Selected.Value),
            Value(MinuteValue1.Selected.Value),
            0
            ),
        ShortDescription: Description_lbl.Text
   }
);

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@ekoz21 ,

The only thing left is the date picker - what do you get if you put

Text(DateValue1.SelectedDate,"dd/mm/yyyy")

in a label Text.
I just ran the exact code here creating a new record with two date/time fields and got the expected result.

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