Answered

Power Automate switches DD/MM/YYYY to MM/DD/YYYY

(0) Share

Report

Posted on by Ed_Churches

Hi Everyone,

I´m new to Power Automate and just found a weird problem: I’m trying to open a .csv file, copy cells (a lot of them with dates), open a excel file and paste the cells there.

The problem is that the dates are originally formatted as DD/MM/YYYY and, for some reason, Power Automate turns them into MM/DD/YYYY (which, essentially, creates a file full of wrong or inexistent dates)

Does anyone know what could be the problem? If the process is done manually everything works fine.

Any help would be appreciated!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ed_Churches Could you please share a screenshot of your PA script?

Was this reply helpful? Yes No
Ed_Churches 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hopefully this helps!

%EXCEL INSTANCE% is the CSV
%EXCELINSTANCE2% is the regular excel file

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Ed_Churches use the window UI elements to format the column for dd/MM/yyyy

or you can refer this: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Date-Format-not-exporting-correctly-from-PAD-to-Excel/td-p/1255552

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Ed_Churches 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! Not sure how to format de column using UI elements... this is my first time using the program.

Let me se If I can make it work.

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ed_Churches Could you please share your excel file

Was this reply helpful? Yes No
Ed_Churches 22 on at

Like
a
(0)

Report
Copy link

Link copied!

I can show you a little bit of the file. The columns I’m struggling with are D and E.

Does it help like this?

Was this reply helpful? Yes No
Verified answer

XRQ57 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I think Power Query will be easier to solve your problem.
Open your csv with power Query and filter if you need and load your new table in a new sheet.

Was this reply helpful? Yes No
Ed_Churches 22 on at

Like
a
(0)

Report
Copy link

Link copied!

You´re right! I was using power automate to also save as pdf and send as an email but, for this part, it would definitely be easier with power query.

Thanks!

Was this reply helpful? Yes No