Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

GetItems from a SharePoint list will convert the DateOnly field to the site timezone?

Posted on 28 Nov 2024 23:51:16 by 1,334
I have a SharePoint list with a column of type DateTime (DateOnly) field named StartDate1, and our site collection has UTC+2 time zone.
 
Now when i directly use SharePoint REST API "/_api/web/lists/getbytitle('bookingcalendardetails')/items(1238)", i will get this value for the DateOnly field:-
 
 
<d:StartDate1 m:type="Edm.DateTime">2024-10-27T22:00:00Z</d:StartDate1>
 
But when i run the GetItems action, it will convert the above Date into 28/10/2024, which is based on the site time zone?
 
 
So can i conclude that GetItems is smart enough to convert the value returned from SharePoint API into the site time zone regional settings? Although for the Created date the time returned by the GetItems will be in UTC and not in the site time zone as follow:-
 
 
So this is a bit confusing? the question is how GetItems treat the DateOnly fields and the Datetime fields in respect to the site local time zone?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard