can someone help me with this?

(1) Share

Report

Posted on by MZ-02090824-0

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '42184' was not valid. The datetime string must match ISO 8601 format.'.
in my excel, the data is 01/01/1991 and when i run my automate it shows 42184. i already change the format to date and still nothing happend. Please send help.

Categories:

Error handling

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Mitanshu 1,650 Moderator on at

Like (0)

Report
1 - Ensure the Excel column is formatted as a Date before importing or using it in Power Automate

2 - When using List rows present in a table action within Power Automate, make sure under Advanced Settings to change format to ISO 8601.

3 - If above two steps doesn't resolve your issue, then change formatDateTime to below: (dynamically replace 42184 to the value you are getting from Excel)

formatDateTime(addDays('1899-12-30', int('42184')), 'yyyy-MM-dd')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No