cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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
Highlighted
Community Champion
Community Champion

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
Highlighted
Community Support
Community Support

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.
Highlighted
Helper III
Helper III

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.

Highlighted
Memorable Member
Memorable Member

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.

 

 

Highlighted
Community Champion
Community Champion

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

Highlighted
Advocate III
Advocate III

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

Highlighted
Community Champion
Community Champion

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

Highlighted
Advocate III
Advocate III

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.

Highlighted
Advocate III
Advocate III

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
Advocate III
Advocate III

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,360)