Skip to main content

Notifications

Community site session details

Community site session details

Session Id : tiweo9NK8BFY2GpB5ye+MG
Power Apps - Building Power Apps
Unanswered

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'

Like (0) ShareShare
ReportReport
Posted on 18 Apr 2023 09:06:09 by

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

Categories:
  • Suggested answer
    CU08040755-0 Profile Picture
    2 on 08 Apr 2025 at 08:00:56
    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'
    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.
     
     
  • MS-13051438-0 Profile Picture
    30 on 11 Sep 2023 at 19:21:07
    Re: 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'

    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. 

  • vibmat Profile Picture
    2 on 20 Jul 2023 at 20:35:00
    Re: 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'

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

  • petrmachac Profile Picture
    4 on 22 Jun 2023 at 08:49:10
    Re: 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'

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

  • Love_Expert Profile Picture
    8 on 03 Jun 2023 at 08:58:02
    Re: 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'

    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. 

  • HenWang Profile Picture
    Microsoft Employee on 19 Apr 2023 at 02:56:20
    Re: 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'

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,786 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard
Loading started