Date columns empty - Power Apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I imported my excel but columns with datetime are empty.

According to the docs

My date is well formated (DD/MM/YYYY)

I don't know what I'm doing wrong.

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Mitanshu 1,658 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In the long run, Excel will give you a lot of problems in being used as a data-source. If you can, change to SharePoint List of Dataverse as your data-source.

Now for your immediate problem, can you try all your dates (DD portion) to be less than 12 and then try importing again? Perhaps make a new Excel with a different name with all days less than 12 and try importing. This will eliminate the possibility that PowerApps tried to read it as mm/dd/yyyy and then had error because month number can't be more than 12.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
90_percent 69 on at

Like
a
(0)

Report
Copy link

Link copied!

I am also having this problem. I am using an excel file for importing the data until i have a DB set up. The Date field is formatted mm/dd/yyyy. it is populated. it is formatted as a date.type. I made a small spreadsheet, to simplify the import, i am importing 35k rows of data, in the prod app. Here's the data.
Here is what the data looks like from a collection:
I have read all the forum posts, about Patching, and date pickers, but i am not using a date picker.

Should i change the date to text like this?

and then try to turn it back into a date value in PowerApps?
I am filtering on the import date to narrow down the lookup commands, so this is an import function to have working.

any suggestions would be apprecaited.

Guy - 90_percent

Was this reply helpful? Yes No
90_percent 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok i found a work around. Not happy with it, but it will work for now.
i used this post for a reference:
Solved: Convert a date into an integer number like SP Date... - Power Platform Community (microsoft.com)

and came up with this:
Text(DateAdd(DateValue("12/30/1899"), Value(LookUp(Test_data, Ticker = TextInput1.Text).Import_Date)),"[$-en-US] mm/dd/yyyy")

Test_data - connection
Import date = 44552
Output = 12/22/2021

#Microsoft - this would be a good thing to fix, seems it has been a problem across platforms for multiple years.

thanks
Guy 90_Percent

Was this reply helpful? Yes No