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

Powerapp date field can't display data from SQL table

Hi,

 

I have a Powerapp app connected to a SQL server database through data gateway. The app works fine except one strange problem; I have an "Order_date" field in the app (show as a calendar icon). This field won't display data from the corresponding column of SQL server table, it is blank. However this field can be used to insert a date to the SQL server table by selecting a date on the calendar, and the data just inserted to the database table though this field won't be displayed when a application refresh is done. The backhand end date data in the SQL server table was never displayed in the Powerapps app on my hand.

 

Can someone help me on this? 

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Level 10

Re: Powerapp date field can't display data from SQL table

I think @v-micsh-msft mentioned the fix will be out in the next release or two.  This means in the next month or two. (3-4 weeks between relelases)

I now believe this since other bugs in the SQL server connector are being fixed (i.e. significant figures on money data type) etc.

I would wait for the fix if you can.  Currently I store dates as an integer yyyymmdd, which also gets around the other bug that dates cannot be currently filtered using the > or < operators, but integers can.

I assume this bug will also be fixed at the same time.

View solution in original post

22 REPLIES 22
Community Support Team
Community Support Team

Re: Powerapp date field can't display data from SQL table

Hi @mzhang,

 

What is the field type of the "Order_date" field?

Staff Eric shared the following:

"

There is currently a known issue with the Date field type for SQL Azure where the Date will not display on PowerApps. Our team has identified the issue and the fix should be out soon (within the next release or two). Please use DateTime in the meantime. 

 

Thanks,

Eric. Software Engineer. PowerApps Staff

"

In this thread: Date, DateTime, SQL AZURE

And currently there is no updates for this issue.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mzhang
Level: Powered On

Re: Powerapp date field can't display data from SQL table

Michael,

 

The data type is date. I tested and found out that the data type date won't be displayed on the Powerapp, but that of datetime can be displayed, however in the latter case there is a 7 hour difference between what's shown on the Powerapp and that in the backhand end database table, appearing as another known issue. So far I have not found a complete solution on how to record and use date/datetime in Powerapps application. These issues are not a show stopper to use Powerapps, but they are not minor issues either. I will be happy to use either date or datetime data type, provided they behave correctly. Is there ETA on when these issues can be resolved?

 

Thanks.

JRaasumaa
Level 10

Re: Powerapp date field can't display data from SQL table

We use a bunch of dates with a SQL on-premise gateway and the only way I've been able to manipulate or compare dates is to store everything in SQL as a datetimeoffset, might be worth a try.

 

 

Meneghino
Level 10

Re: Powerapp date field can't display data from SQL table

I think @v-micsh-msft mentioned the fix will be out in the next release or two.  This means in the next month or two. (3-4 weeks between relelases)

I now believe this since other bugs in the SQL server connector are being fixed (i.e. significant figures on money data type) etc.

I would wait for the fix if you can.  Currently I store dates as an integer yyyymmdd, which also gets around the other bug that dates cannot be currently filtered using the > or < operators, but integers can.

I assume this bug will also be fixed at the same time.

View solution in original post

panterra
Level 8

Re: Powerapp date field can't display data from SQL table

Hi,

 

I am having issues filtering SQL Date Time columns as well.  Has this fix been released yet?

 

If so, do you know if there are examples of the syntax used for filtering a table using one of its date columns?

 

Much Thanks,

Sean

Meneghino
Level 10

Re: Powerapp date field can't display data from SQL table

panterra
Level 8

Re: Powerapp date field can't display data from SQL table

@Meneghino Thank you for the prompt response.  This will definitely help me move forward.

panterra
Level 8

Re: Powerapp date field can't display data from SQL table

Is there a rough timeline for when functionality will be available to Delegate Filters to SQL Data Sources that include > or <  ?

 

We are trying to determine whether it would be worth waiting for this functionality or implementing one of  the provided work arounds.

Highlighted
panterra
Level 8

Re: Powerapp date field can't display data from SQL table

@Meneghino Is there a timeline for when functionality will be available to Delegate Filters that include DateTime columns and greater than or less than to SQL Data Sources?

 

We are trying to determine whether it would be worth waiting for this functionality or implementing one of  the provided work arounds.

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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