Convert date time format in a create csv table format.

(0) Share

Report

Posted on by Watkins

Hi All,

I have a flow which reorganises a CSV table,

I would need to format the datetime differently currently it comes in as 2024-12-08T20:59:57 +00:00

So I would be looking for a way to format this differently as this date format is not working with my current system, which this CSV file then gets uploaded into. I would need to keep the date and time just not the extra bit with the T and +00:00 as the other system does not recognise this as a date, to be clear I just want a few different ways to format the date differently within a split table similarly to the expression I put below it does not matter what specifically the format needs to be just really would want to know how to use these two expressions together to format the date differently so that it does work when it gets uploaded.

formatDateTime(split(item(),';')?[2], 'M/dd/yyyy h:mm tt')

I have tried the above expression but this did not work.

Could someone help me with how this expression should look using split and formatdatetime() if it is even possible?

Thanks.

Regards,

Watkins

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 69,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Just use a formatDateTime with a custom format. Something like this.

formatDateTime(split(item(),';')?[2], 'MM/dd/yyyy hh:mm:ss')

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Watkins 70 on at

Like (0)

Report
Copy link

Link copied!

Pstork1 ,

Thanks for the reply,

I did try this and got this error.

The time format comes in as 2024-12-08T21:59:57+00:00.

Looks like it doesn't understand its a date/time value? Is there anything I could do in PowerAutomate to fix this?

Thanks.

Was this reply helpful? Yes No