Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter date base on two date comparision

Posted on by 124

I though this would be simple but it turn out very strange. I have sharepoint list (Submission List) with two date columns, 'Due date' and 'Submission Date'. I am using gallery to show the list and now I want to filter the list in the gallery that 'Submission Date is greater than 'Due Date'. My code as below. It works if I compare it with today's date but when compare the two date, it return blank. I do have the list with 'Submission Date' less than 'Due Date'. The column is Date Time column with include time turn off

 

Filter('Submission List', 'Submisssion Date' > 'Due Date')

 

I do want delegation to work if that possible.

  • Verified answer
    daydinho10 Profile Picture
    daydinho10 124 on at
    Re: Filter date base on two date comparision

    OK, I am able to solve this problem by using add column inside filter so there is additional column that I can use to filter. 

    Filter(
     AddColumns(
     'Submission List',
     "IsLate",
     If(
     'Submission Date' > 'Due Date',
     true,
     false
     )
     ),
     IsLate = true
    )

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard