Power Platform Community Forum Thread Details

Date format changes when exporting data from Sharepoint List to Excel table

Hi all,

Currently trying to build an excel doc that takes Sharepoint list data and puts relevant data into a table in an excel file.

I've got the data flowing nicely, but for some reason the dates act funky when exporting.

Behavior:

Select maps the data from a "Get Items" action. As you can see it pulls "PolicyBoundDate" value from the Sharepoint list as UTC ISO date/time - in this case "2022-02-10T20:01:00Z". Using the convertFromUTC() function and formatting (to dd/MM/yyyy hh:mm tt", it's output as "11/02/22 9:01 AM".

Later in the flow, I then add the data above to the table in my excel document, here you can see it's passed the formatted date/time "11/02/22 9:01 AM" and reports the same as the output.

However, once I check on the excel document generated, the time format has changed? And not only that but it changes the data, so when I format it as required (dd/MM/yyyy hh:mm tt) it swaps the day and month??

Excel app (file downloaded)

Excel online (opening directly from Sharepoint online)

So essentially, Sharepoint List (2022-02-10T20:01:00Z) > Power Automate (11/02/22 9:01 AM) > Excel (02 01 2022 9:01 [Excel App] // 2/11/2022 9:01 [Excel online])

Really confused how to get consistency with the formatting here, i'd really like to not have it as a string as being filterable as a date value is required. Note all apps and sites are set for the same region for formatting (New Zealand).

Any insight or help is greatly appreciated!!

Cheers 🙂

Quick Links

Leaderboard > Power Automate