cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamB2
Level: Powered On

Filter gallery with items with a date after today only

Hello

 

I have a drop down list which users select a topic from, then the gallery filters according to available items. Code for the filter is dead simple & works: Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE).

 

I need to add to this so the filter only shows items in the sharepoint list which are future dated. In the list there is a field with date & time (StartDateTime). 

 

How do I do this?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Filter gallery with items with a date after today only

Try:

Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE &&
Date(Year(StartDateTime), Month(StartDateTime), Day(StartDateTime)) > Today())

View solution in original post

Anonymous
Not applicable

Re: Filter gallery with items with a date after today only

Hi,

 

I'm not sure I understood, but you can add an other condition in your filter like Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE, StartDateTime > Today())

 

Is that what you wanted ?

 

Regards 

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Filter gallery with items with a date after today only

Try:

Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE &&
Date(Year(StartDateTime), Month(StartDateTime), Day(StartDateTime)) > Today())

View solution in original post

Anonymous
Not applicable

Re: Filter gallery with items with a date after today only

Hi,

 

I'm not sure I understood, but you can add an other condition in your filter like Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE, StartDateTime > Today())

 

Is that what you wanted ?

 

Regards 

View solution in original post

Highlighted
SamB2
Level: Powered On

Re: Filter gallery with items with a date after today only

That's exactly what I wanted. Thank you very much!

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,835)