Unanswered

SharePoint Date field showing up as String in PowerApps

(0) Share

Report

Posted on by kilaj1

257

I may just need to do a bit more "youtubing" and "googling", but from what I can see it should be working as is. I have a SharePoint list with a date and time column.

I add the Form control to the power app canvas and connect to the SharePoint list, the date input shows up as a text box and the data type is string.

I've tried creating a new column in the same list and its the same result. I created a brand new list with just a single Date field that that works. The list that isn't working was created using the Import from spread sheet option originally, there are over 90 fields, didn't want to create them manually. Could this be the cause? is there something else I can do to link it to a PowerApp Date control?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@kilaj1 ,

A text box will always hold a string, whether it be Text, Date or Numeric. In the case of a date, it will display the field in the data source, but if you want to refer to it as a date, you need to use DateValue(TextBoxName)

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
kilaj1 257 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response, I actually figured it out after retracing my steps. I created a table in excel and I used the "Add app" function in SPO. For some reason when its imported its set to a number field, even if i change it in the list after the fact or even create a new column it would not pull the correct column type over into PowerApps.

I then poked around in the Site contents area of SPO and saw the "New"> "List" option
This allowed me to specify the column types before creating the list.

I recreated the excel file and tried pre-formatting some of the columns, had mix results. In one case it created the list but still changed everything to a number field. Another case it it had a JSON error and didn't create the list. another an general error but it did create the list but missed about 15 columns.

What it came down to I think was the "Title" data type being changed from default, which was the first column in my list. I left it with a Type of "Title", and proceeded to update the other fields and the list created with no issues, then in PowerApps it pulled in the correct controls.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @kilaj1 ,

This is another reason you should watch this video from Shane Young @Shanescows .

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
kilaj1 257 on at

Like
a
(0)

Report
Copy link

Link copied!

Funny you mentioned @Shanescows , I've been using his videos for most if not all of my PowerApps learning. Its the reason I'm using SharePoint List now vs what I was doing before, hardcoding everything in the app.

I I think I figured things out (although its mentioned a bit in that video you linked), this was more of a Excel to SPO/powerapps "issue" than anything. When I used the import from excel function it created the columns all as numbers as mentioned before. I think that the columns got registered (locked in) as that data type behind the scenes, I tried recreating the column with the same name and it didn't work. when I created a new column with a different name with a date data type it worked.

Was this reply helpful? Yes No