Answered

Change the date format as dd-MM-yyyy

(0) Share

Report

Posted on by mohamed18

Hi everyone

I have a cell "date" in a excel sheet which is in a date format, but on flow I have this error message when I format the date in dd-MM-yyyy: Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '44683' was not valid. The datetime string must match ISO 8601 format.

Can someone give me some advice

Thank you

All responses (4)

Answers (1)

mohamed18 43 on at

Like (0)

Report

Re: Change the date format as dd-MM-yyyy

Thank you @RobElliott, my flow is working fine now !!
Verified answer

RobElliott 10,166 Super User 2025 Season 1 on at

Like (1)

Report

Re: Change the date format as dd-MM-yyyy

Excel stores dates as an integer. If you are using a List rows present in a table action make sure you select the DateTime format in the action to ISO 8601.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
mohamed18 43 on at

Like (0)

Report

Re: Change the date format as dd-MM-yyyy

I still have the same error message, I think it's due to the date which is provided by excel to PA as "44683" but the format is set to date on excel
CU31011410-0 142 on at

Like (0)

Report

Re: Change the date format as dd-MM-yyyy

Hi,

If you're after converting the date then this might help you:

It can be found using this method:

Some screenshots of your flow and data output might help others assist you as it's not easy reading what you're trying to do or your steps. You can snip and paste directly into replies.