web

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

Power Platform CommunityForums Power Apps - Error Handling can someone help me wi...

Power Apps - Error Handling

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mitanshu 1,644 Moderator on at

Like (0)

Report
can someone help me with this?

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

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Apps

#1

WarrenBelz 663 Most Valuable Professional

#2

Michael E. Gernaey 398 Super User 2025 Season 2

#3

developerAJ 235

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans