Answered

Filter to dates greater than or equal to now

(1) Share

Report

Posted on by aterry29 Microsoft Employee

Hi, I have a SharePoint list with a column for date.

I am trying to create a power app that shows these items in the list, with only show dates greater than or equal to today.

I am struggling to figure this out.

I used a suggested formula from powerapps which shows a good enough view but there are past dates in it. I don't want to have to delete the past date from my list. I'd like to just set up the filter that only shows items for today and future dates instead.

I am sure this is very simple, I just don't know enough about syntax, operators, etc to do this quickly. Any suggestions?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

it is usually datecolumn >= now()

do you know what your date column is called
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

So if i was to pop it into what you have currently i would do:

SortByColumns(Filter([@'Upcoming ROB'],StartsWith(Title,TextSearchBox1.Text)&&DataColumnName >= Now()),"Title",If(SortDescending1,Descending,Ascending))

the bit in red i would replace with your column name.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @aterry29,

Do you want to filter your gallery based on Date when it is greater than or equal to today?

Could you please tell me that if this column is a Date only column?

I think @AJ_Z has provided a correct formula that could solve your problem, please mark his reply as an answer.

Thanks for your cooperation.