Convert date & time in power automate when exporting from SharePoint into csv

(0) Share

Report

Posted on by Eeyore2005

119

Dear All,

I am working on a flow that exports SharePoint list into csv file.

In the SP list I have two Date&Time columns: "Start Date" and "End Date" and then 2 default fields - "Created" and "Modified".

However the time in the SP list is not the same as in the csv exported from the SP list:

Created - this field in SP list shows +1 hour compared to CSV
Modified - this field in SP list shows +1 hour compared to CSV
Start Date - this field in SP list shows + 2 hours compared to CSV
End Date - this field in SP list shows + 2 hours compared to CSV

SharePoint list shows the time correctly, so the CSV needs to be adjusted.

Could you please advise how to write the expression for these 4 columns in the "Select" step of my flow?

Thank you very much in advance.

SP list:

Excel:

Flow:

Select Step:

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (2)

Report
The Get Items connector, like all SharePoint connectors, returns date values as UTC datetime.

To convert the date to your timezone, use the function convertFromUtc().

E.g.

convertFromUtc(item()['Created'], 'W. Europe Standard Time')

Select your timezone from https://learn.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11

Was this reply helpful? Yes No