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

Foto 13-08-2023 o...

I have the same question (1)

All responses (13)

Answers (0)

v-jefferni on at

Like (0)

Report

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

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.

Schermafbeelding...

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

Like (0)

Report

Hi @VandenOstende ,

You can find the setting here:

Best regards,

Was this reply helpful? Yes No
VandenOstende 6 on at

Like (0)

Report

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.

Schermafbeelding ...

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

Like (0)

Report

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

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

Schermafbeelding ...

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

Like (0)

Report

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

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

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

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