Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Filter gallery of Sharepoint list by date

I am having problems filtering a gallery based on a date column in a Sharepoint list.

Sharepoint List = OnboardTasks

Date Column = Due_Date

Calculated Column = DDNumber

Formula =VALUE(YEAR(Due_Date)&RIGHT("00"&MONTH(Due_Date),2)&RIGHT("00"&DAY(Due_Date),2))


The following filter works fine but does not filter dates:

Current filter = Filter(OnboardTasks, Completed=false, Dropdown2.Selected.Value = Assigned_x0020_To)


Things I have tried that give blue warning: “Part of this formula cannot be evaluated remotely…”


Filter(OnboardTasks, Due_x0020_Date>08/01/2017, Completed=false, Dropdown2.Selected.Value = Assigned_x0020_To)

Filter(OnboardTasks, Due_x0020_Date>Date(2017,8,15), Completed=false, Dropdown2.Selected.Value = Assigned_x0020_To)


I have tried MANY ways with no success. I have tried to use the calculated column as well.


When the calculated column is placed on a label, it displays with 7 zeros after decimal.


Post Patron
Post Patron

Hi @TMR 

You can watch this video.

Also request you to please subscribe this PowerAutomate channel.

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,435)