Reply
Level: Powered On
Posts: 11
Registered: ‎11-20-2017
Accepted Solution

Date from SQL Azure db is not displaying in app.

Hey everyone,

 

I have an app that is a form that connects to and populates a SQL Azure table. I have a date/time picker on the form that is successfully updating the record in the table however on my details screen in the app, it is not showing the date/time info, it is blank. The colum is formatted as datetime in SQL.  Any ideas? I tried creating a new blank app from data from the table and it is blank there as well after powerapps creates the standard app. 


Accepted Solutions
Microsoft Employee
Posts: 38
Registered: ‎08-11-2016

Re: Date from SQL Azure db is not displaying in app.

This fix has been deployed to all regions. You should no longer see this issue.

View solution in original post


All Replies
Highlighted
Level: Powered On
Posts: 10
Registered: ‎01-15-2018

Re: Date from SQL Azure db is not displaying in app.

I am having the same problem across multiple apps and multiple tables and databases. Anything with a datetime value doesn't seem to display properly although I can see it in the source table that there is data.

Level: Powered On
Posts: 11
Registered: ‎11-20-2017

Re: Date from SQL Azure db is not displaying in app.

Hey XenophonD,  is this just recent for you as well? I swore this was working on my app previously but wasn't sure if a change i made affected it. I just checked another of my apps and it is not working either. A recent new bug?

Level: Powered On
Posts: 10
Registered: ‎01-15-2018

Re: Date from SQL Azure db is not displaying in app.

VERY recent. I'm actually opening an issue with Microsoft about it because everything was working perfectly fine last week. I think we are each other's confirmation that this is an issue out of our control.

Level: Powered On
Posts: 11
Registered: ‎11-20-2017

Re: Date from SQL Azure db is not displaying in app.

Ok great, thanks for confirming. Please let me know if you hear of a resolution. 

Level: Powered On
Posts: 10
Registered: ‎01-15-2018

Re: Date from SQL Azure db is not displaying in app.

They confirmed that other customers are seeing the same problem related to SQL databases. So it's definitely not just us.

Level 10
Posts: 2,013
Registered: ‎11-07-2016

Re: Date from SQL Azure db is not displaying in app.

Level 8
Posts: 39
Registered: ‎10-30-2017

Re: Date from SQL Azure db is not displaying in app.

Here as well...
Level 10
Posts: 2,013
Registered: ‎11-07-2016

Re: Date from SQL Azure db is not displaying in app.

Wall of silence form Microsoft...

Any input from @CarlosFigueira or @audrieg or @v-micsh-msft?

Level: Powered On
Posts: 10
Registered: ‎01-15-2018

Re: Date from SQL Azure db is not displaying in app.

[ Edited ]

I've been working with Microsoft on this the past few days and they told us the made a change to the SQL connectors but did a roll back to at least our environment and tried to confirm with them if it was everyone or not. It sounded like they rolled back the U.S.'s environment to a SQL connector version that shouldn't negatvely affect the datetime fields. I assume the issue still exists for some of you.