You’re offline. This is a read only version of the page.
Announcements
171
Hello everyone I have a problem reading a date field from excel in Powerapps. When I try to read it out in PowerApps in my datepicker I get the following error message: The expected value "45328.9583333333" must be a valid RFC 3339 format for "Date-Time". Permitted ISO 8601 formats: 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss thh:mm', 'YYYY-MM-DDThh:mm:ss'.
The interesting thing is that i can patch the date from the datepicker into the excel but when i read it out i get the error message and the datepicker is empty.
Thats how i patch it:
Share
Report{'dateColumn': datepicker.SelectedDate +1};
and thats how i view it in the datepicker
gallery.Selected.dateColumn
hey @alt88
can you try this please:
All responses (
Answers (
DateAdd(
DateValue("1899-12-31"),
RoundDown(gallery.Selected.dateColumn, 0),
Days
) + Time(
Hour(Mod(gallery.Selected.dateColumn, 1) * 24),
Minute(Mod(gallery.Selected.dateColumn, 1) * 1440),
Second(Mod(gallery.Selected.dateColumn, 1) * 86400)
)
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
