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 🙂
