Unanswered

Microsoft Graph API Returned Dates from SharePoint Online

(0) Share

Report

Posted on by Bluenose

Hi,

I'm using the Microsoft Graph API to get data from a SharePoint Online list. Some of the date fields that are being returned are a day before the date that is recorded on the SharePoint Online list!

Also, I am based in Dublin, Ireland and the dates are being returned in a US format and I would prefer these dates returned in a UK / Irish format.

I would be grateful for any assistance with both of these issues.

Best regards,

Paddy

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @Bluenose ,

For your first question:

The datetime returned by the API is in UTC timezone.

Please use Dateadd function to convert it.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-dateadd-datediff

For second question:

We can use Text function to format the datetime.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-text

Best Regards,

Wearsky

Was this reply helpful? Yes No
Bluenose 49 on at

Like (0)

Report

That's it.

Thanks for your great support. Very useful and responsive community.

Best regards,
Paddy

Was this reply helpful? Yes No