Answered

Filter gallery with items with a date after today only

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

LRVinNC 2,297 on at

Like
a
(1)

Report
Copy link

Link copied!
Try:
Filter(MYSHAREPOINTLIST, Dropdownbox.Selected.Value = MODULETITLE &&
Date(Year(StartDateTime), Month(StartDateTime), Day(StartDateTime)) > Today())

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No