web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Show item if start dat...

Power Apps - Building Power Apps

Unanswered

Show item if start date is greater than or equal to today

Like (0) Share

Report

Report

Posted on 13 May 2024 14:58:59 by laura_warwick

30

I'm trying to filter my gallery by showing only events (items) from today onward. I've tried this formula in the items section:

Filter('Training Events List', If(StartDateTime <= Today())

And it's showing an error. StartDateTime is a date column in the SharePoint list (data source) Training Events List.

Categories:

General Questions

All responses Img

All responses (2)

Answers Img

Answers (0)

timl 35,242 Super User 2025 Season 2 on 13 May 2024 at 16:46:48

Like (0)

Report
Re: Show item if start date is greater than or equal to today

@QuentinDURIEZ is correct here.

However, if you want to return items where startdatetime is greater than or equal to today, you would use the greater or less than operator (>=) in your expression.

Filter('Training Events List', StartDateTime >= Today() )
QuentinDURIEZ 507 Moderator on 13 May 2024 at 15:32:15

Like (1)

Report
Re: Show item if start date is greater than or equal to today

Hi,

Simply remove the If statement if the filter formula :

Filter('Training Events List', StartDateTime <= Today())

Regards,