web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps can someone help me wi...

Power Apps

Suggested Answer

can someone help me with this?

(1) Share

Report

Report

Posted on by MZ-02090824-0

2

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:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mitanshu 1,658 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Join the conversation