You’re offline. This is a read only version of the page.
Announcements
Share
ReportI'm new to Power Apps and I'm trying to solve a problem reading the date from an Excel sheet connected to my app.
the data format of the column is "dd/mm/yyyy" and using a date picker I can write it correctly in the Excel record.
Unfortunately I can't read it from the file afterwards.
Setting ThisItem.DATA (where date is my Excel column) returns an error like:
The expected value "45512.9166666667" must be a valid RFC 3339 "date/time" format. Allowed ISO 8601 formats: 'YYYY-MM-DDThh:mm:ssZl, 'YYYY-MM-DDThh:mm:ss±hh:mm l , 'YYYY-MMDDThh:mm:ssl.
I couldn't find any solution suggestions for this.
Could you give me advice to resolve this error?
Error.jpg
All responses (
Answers (
739
