Power Platform Community Forum Thread Details

Hi, I am getting some rows from excel based on the value, I need to work with two columns dateTime type:

I choose the Date format option : " Format ISO 8601 "

But only one of them is well converted with the right format but the second one comes as a string:

Excel file:

***The format in Excel is the same for both columns.

Flow:

Result:

Why the option "Format ISO 8601" only works for one value?

I just need the 2 values in 'yyyy-MM-ddTHH:mm:ssZ' format.

Can I have some help please? thank you !

Categories:

This seems to be a issue with excel. that number shown for second date column in compose action represents number of days from 1st Jan 1900.

May be try to format the second date column as text and see whteher tthat works for you ?

Else workaround would be like this as shown in post for adding the 1st jan 1900 to the integer to get the date.

Thanks & Regards,

Nived N 🚀

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

DateTime Format ISO 8601 only converting one column from Excel