Unanswered

date format change after export to excel

(0) Share

Report

Posted on by twister

418

Hi, I have flow from Sharepoint List export to Excel sheet. But after completed export to excel the date in excel sheet not same as in sharepoint list and the format also different.. how this actually happen? can anybody explain?

Sharepoint List:

Excel:

Thanks

Categories:

Process mining

I have the same question (0)

All responses (3)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hi @twister

Excel and SharePoint deal with dates differently. Check your SharePoint time zone settings.

Was this reply helpful? Yes No
ChrisMendoza 425 on at

Like (0)

Report

I'm thinking that you should format the UTC to Text before you export to Excel. Pretty sure Power Automate is passing the UTC value that flow understands as Text and not a number. An export from the SP List to Excel, without Flow, correctly displays mm/dd/yyyy as a custom format with the underlying 'General' format is a serial date I would expect from Excel. Take a look at https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/.

Was this reply helpful? Yes No
Samkeni358 2 on at

Like (0)

Report

Hi @twister ,

I think SharePoint DateTime values defaults to UTC.
You can create calculated columns on SharePoint for both columns with the formula below and use the new columns for your analysis:

Formulae:
=TEXT([Verified Date]), "dd/MM/yyyy HH:mm"])
=TEXT([Endorsed Date]), "dd/MM/yyyy HH:mm"])

Let me know if this works for you.

Was this reply helpful? Yes No