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

Sort Gallery by Datetime

Hello Community, 

 

I have SQL server as a data source. In the table there is a column with the data type datetime.

Now I want to sort my gallery so that NO dates with the date "2000-31-21 00: 00: 00.000" are displayed.

I tried with: Filter (data source; Not (columnDate = "2000-31-21 00: 00: 00.000")), but the data is still displayed to me.

Do you have any idea why that is?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Hi @Alice87 , 

 

Please read the limitations chapter of this article:

https://docs.microsoft.com/en-us/connectors/sql/

 

As a workaround add a new column on SQL table with columndate as text or as an int (there are some calculations to do) or create a view based on the same  logic. 

View solution in original post

1 REPLY 1
Highlighted
Memorable Member
Memorable Member

Hi @Alice87 , 

 

Please read the limitations chapter of this article:

https://docs.microsoft.com/en-us/connectors/sql/

 

As a workaround add a new column on SQL table with columndate as text or as an int (there are some calculations to do) or create a view based on the same  logic. 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,824)