Power Platform Community Forum Thread Details

Hi All,

I want to update a DateTime SharePoint column named "PreviousVersionModified", but i am a bit confused on the timezones.., now our site collection has this Regional settings:-

and when i tried to update the column using direct API call, as follow:-

where i am passing this inside the "FieldValue" >> utcNow('MM/dd/yyyy HH:mm'),, where the datetime will not be added based on the UTC time zone but it will be added based on the site collection time zone, so when i pass the utcNow('MM/dd/yyyy HH:mm') .. the actual date inside the SharePoint back-end that got added will be UTC + 8 hours...

But if i update the same column using the SharePoint Update Item action:-

the datetime added at the SharePoint back-end will be in the correct UTC .. when i am talking about the SharePoint back-end , i mean the date/time column value when i retrieve it using API call

So, if i want to use API call approach, how i can tell SharePoint that the datetime i am passing should be added based on the UTC time zone and not based on the site collection timezone?

Thanks

Categories:

Building flows