How to store in SharePoint two dates/time as all Dates

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have two DatePicker (Start and End) in my app, for instance I selected from Feb 15 to Feb 16, see below:

From: Tuesday, February 15, 2022

To: Wednesday, February 16, 2022

As part of the app, a collection of dates DateRange is created with the From and To dates for different purpose.

I noticed that the dates in the collection have the current time, as below:

First(DateRange).Date shows as:

Start 2/15/2022 11:18 AM

Last(DateRange).Date shows as

End 2/16/2022 11:18 AM

*time when I run the app

When it is Patch-ed to SharePoint, I use as:

{

From: First(DateRange).Date,
To: Last(DateRange).Date,

}

Therefore date/time fields are stored in SharePoint with 11:18 AM time (time when app was run). My request is to store the dates as below example:

Start 2/15/2022 12:00 AM

End 2/16/2022 11:59 PM

What instruction(s) should I add to store the dates in SharePoint as it?

Thank you

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Willy-C ,

Can you please supply your Patch code (in Text). There is no reason these two date picker values cannot be stored as dates (their time will be 0:00 if you do not supply one). The Created value however will reflect when you created the record (data and time).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren
Here is the patch code:

Patch(
'Time Off Requests',
{
   Title: curUserEmail,
   From: First(DateRange).Date,
   To: Last(DateRange).Date,
   TimeOffType: {
         Id: selectedType.ID,
         Value: selectedType.Title,
         '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
   },
}
);

The SharePoint fields are updated with the full value (date and time) from DateRange.Date collection.
Keep in mind I would like to reset the time of the two fields before patching to reflect as follows:
Start as 2/15/2022 12:00 AM
End as 2/16/2022 11:59 PM

Thanks
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Willy-C ,

Now the question is how do you collect DateRange and when?
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to override the time for Start and To SharePoint Column while patching by tweaking the two dates as below:

Start: DateTimeValue(Text(First(DateRange).Date,DateTimeFormat.ShortDate) & " " & Time(0,0,0),"en-US"),
To: DateTimeValue(Text(Last(DateRange).Date,DateTimeFormat.ShortDate) & " " & Time(23,59,0),"en-US")

Thanks