How to resolve error message - Expected value '' to be a valid RFC 3339 'date-time' format. Allowed ISO 8601 format(s): 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss±hh:mm', 'YYYY-MM-DDThh:mm:ss'

(0) Share

Report

Posted on by Community Power Pla...

Kindly help with above soft error message. Please refer attachment for more details.

Categories:

Building Power Apps

Error message.jpg

I have the same question (3)

All responses (6)

Answers (0)

HenWang Microsoft Employee on at

Like (0)

Report

Hi @Anonymous ,

For this issue, it is clear that you are playing canvas app and after maybe you type the datetime value, which is not valid for power app, this error showed up.

If this is the case, you might need to provide the date format at the same time: Please try below formula
Text(Your_own_date_time_value,DateTimeFormat.UTC)

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Love_Expert 8 on at

Like (1)

Report

IfError(IsBlank(Text(DateTimeValue(ThisItem.DateValue),"mm-dd-yyyy")),Blank(),Text(DateTimeValue(ThisItem.DateValue),"mm-dd-yyyy")
)

Then make sure that from the settings, Formula-level error management is turn on.

Was this reply helpful? Yes No
petrmachac 4 on at

Like (0)

Report

Your syntax helped me to treat the error. Thank you.

Was this reply helpful? Yes No
vibmat 2 on at

Like (0)

Report

Can you please tell me where to enter is formula. Thanks!

Was this reply helpful? Yes No
MS-13051438-0 30 on at

Like (0)

Report

Hello, when I got this error on the field that imports data from Dataverse, I just deleted and re-added that feild. And the error disappeared. Not sure if this is going to help you guys but I wanted to share my experience regarding this.

Was this reply helpful? Yes No
Suggested answer

CU08040755-0 2 on at

Like (0)

Report

I had the same issue for my Submission Date column in sharepoint. when i was try to populate the date picker in canvas app from this column. Value in sharepoint was correct but not reflecting in power apps. it was working fine in Dev but had this issue in prod (earlier it wasn't there)

I simply fixed this issue by change my Date column in sharepoint to include Time.

Was this reply helpful? Yes No