cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
caballar
Level: Powered On

Date from Access Web App not showing in PowerApps

Hello,

 

My PowerApp is connected to an Access Web App, but the date from the web app is not showing up in the PowerApp. I think this has something to do with the SQL Azure labe of "date" instead of "datetime", but I'm not sure how to fix this. Can someone help?

 

Thanks.

 

2016-12-14 11 50 10.jpg2016-12-14 11 50 33.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff erga
Power Apps Staff

Re: Date from Access Web App not showing in PowerApps

Hi @caballar,

 

Thank you for reporting this issue. There is an known issue with SQL's "Date" types not displaying properly on PowerApps and we are working on a fix within the next few releases. If you are reasonably able to, please use "DateTime" in the meantime. 

 

We apologize for the inconvenience and thank you for your patience! 

View solution in original post

3 REPLIES 3
Power Apps Staff erga
Power Apps Staff

Re: Date from Access Web App not showing in PowerApps

Hi @caballar,

 

Thank you for reporting this issue. There is an known issue with SQL's "Date" types not displaying properly on PowerApps and we are working on a fix within the next few releases. If you are reasonably able to, please use "DateTime" in the meantime. 

 

We apologize for the inconvenience and thank you for your patience! 

View solution in original post

ejlevitt
Level: Power Up

Re: Date from Access Web App not showing in PowerApps


@erga wrote:

Hi @caballar,

 

Thank you for reporting this issue. There is an known issue with SQL's "Date" types not displaying properly on PowerApps and we are working on a fix within the next few releases. If you are reasonably able to, please use "DateTime" in the meantime. 

 

We apologize for the inconvenience and thank you for your patience! 


 

Hi, I have having the same issue where date fields from an Access Web App are not showing in PowerApps.  I've read several support articles that say to use "DateTime" sub-format, but that doesn't seem to work for me either.  However, I don't know if I'm applying it in the right place.  In Access, I am opening the table that contains the dates, and then changing the date field's sub-type to Date with Time.  When I republish the web app, and go back to PowerApps and add the date field, it still does not show.

 

I've also tried to apply the "DateTime" to the field when I add it to my PowerApps app; however, I can't seem to get the syntax correct.

 

This is just a simple date field, but I can't seem to figure out how to get it to display in my PowerApp.

Meneghino
Level 10

Re: Date from Access Web App not showing in PowerApps

Correction, this has not yet been fixed in version 2.0.600.

Any idea when?

Strangely it seems we can now Patch to date only columns but not see them.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,620)