cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emcleod3
New Member

Excel Dates Not Appearing in PowerApps

I've tried everything and no matter, my Excel dates do not show up in my PowerApps app. Varying formats, read many posts with suggestions and nothing works.

 

My column(s) in Excel are set as "Date" using a short date format.

In PowerApps, the Excel fields are being accepted as dates and display with the calendar drop-down, however, the actual data is BLANK. All other data for the row(s) come in correctly. 

 

For example, I can create a sample canvas app with a data table, a form, a gallery and setup a simple Excel table with a few columns, some setup as Date with a short date format, fill in a few rows and connect. The dates NEVER appear in my app. 

 

Please help!

6 REPLIES 6
WarrenBelz
Super User
Super User

Hi @emcleod3 ,

One of the many reasons Excel is a terrible data source - format the date as Text in Excel and you will need DateValue() to read them and Text() to write them back. If you have access to SharePoint, I strongly recommend you using it instead.

 

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.

Visit my blog Practical Power Apps

emcleod3
New Member

Hi thanks,

I'm not to use SharePoint for this project.
I do see PowerApps now allows Excel tables to have formulas and allows multiple users accessing the Excel file which makes a big difference. So my last issue is Dates and I see some people have gotten around the issue, but none of their work-arounds work for me.

@emcleod3 ,

If you really need to go with Excel, make sure you do not have more than 2000 rows in any table and also be aware that the Excel file cannot be opened outside Power Apps while any app is running and you should not modify anything outside Power Apps. You might look at the Date suggestion I posted.

emcleod3
New Member

Thanks. I have seen solutions where the column in Excel is formatted as "Date" and this seems to work for others. Do you know of how I can get that to work for me?

@emcleod3 ,

I am not an Excel user, but have seen a lot of posts similar to yours and formatting as Text solves the issue. Here is a good post describing the challenges and some possible solutions.

 

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.

Visit my blog Practical Power Apps

 

 

emcleod3
New Member

Hello,

Yes I have seen those posts and have seen solutions that have worked for people using text in Excel and have  also seen solutions using dates in Excel (which is what I need to do).

I just must be missing a step or doing something wrong.

If anyone out there can let me know what I am doing incorrectly, please let me know.

Thanks  in advance.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,795)