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 VandenOstende

What to do with this error?
I have an excel table connected to this canvas app. And in this table is a column for date selection. But I get this error. How do I resolve this issue? Also if I pick a date, the date won't update in the excel table, but the other items are working as it should.

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 attatched a screenshot. But its in dutch language.

Categories:

Building Power Apps

I have the same question (2)

All responses (13)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VandenOstende ,

Could you please share more details about your scenario? What's the format of this column? Is it a Date only column in Excel table or a date and time column? In addition, have you enabled the ISO 8601 support in PowerApps settings?

Best regards,

Was this reply helpful? Yes No
VandenOstende 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply.

I have an Excel worksheet with data, that I can edit using the app created in power apps.
The data that I'm entering in Excel/Power Apps are some sort of parcels, and I need the function for entering a date (no time) when the parcel arrives.
I formatted the column as a short date column.
My knowledge about Power Apps isn't that big, I new to this. So I don't think that I enabled the ISO 8601 support in Power Apps settings.
I will try and look this up now.

I've added a screenshot of my Excel worksheet.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VandenOstende ,

You can find the setting here:

Best regards,

Was this reply helpful? Yes No
VandenOstende 6 on at

Like (0)

Report
Copy link

Link copied!

I've got it enabled, and the date get updated in Excel now. So far so good.
But I still get the error. Screenshot provided.
Can it be because of the date and time in power apps? Because I only have the option for the date in Excel. There is no need for time registration.
But in Power Apps there is the option to fill in the time. And I can't seem to remove that option.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VandenOstende ,

What's the date format in Excel table? Please check if Default of this Data Card is set as ThisItem.'DATUM IN'

Best regards,

Was this reply helpful? Yes No
VandenOstende 6 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I attached a screenshot of my Excel table format.
The Data Card is set as ThisItem.'DATUM IN'

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VandenOstende ,

Could you please then check the actual values of the Datum In column in the formula bar?

Best regards,

Was this reply helpful? Yes No
cowboyayanami 2 on at

Like (0)

Report
Copy link

Link copied!

I had the same Error, either.

My DataSource is Excel, too. And I have turn on ISO 8601 as follow.
And setting of Excel column is following:

What to do with this error? In fact, it doesn't affect my App running, but the Error information always on the top of the screen. It's ugly.
@v-jefferni

Was this reply helpful? Yes No
msalgado 4 on at

Like (0)

Report
Copy link

Link copied!

Tengo el mismo problema, llevo más de una semana buscando y probando de todo, pero nada

Was this reply helpful? Yes No
0xdani 2 on at

Like (0)

Report
Copy link

Link copied!

Para solucionar, el idioma del navegador debe estar en inglés.
En Power Apps, dentro de un label, colocar la función language(). Debería salir "en-US" para comprobar.

Was this reply helpful? Yes No