web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter date base on tw...

Power Apps

Answered

Filter date base on two date comparision

(0) Share

Report

Report

Posted on by daydinho10

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

daydinho10 124 on at

Like
a
(0)

Report
Copy link

Link copied!
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 )

Was this reply helpful? Yes No

Join the conversation