web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Convert date & time in...

Power Automate

Answered

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

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Chriddle 8,686 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
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

Join the conversation