Power Platform Community Forum Thread Details

I have a PowerApp with a dropdown that brings in items from a SharePoint list. This is working great, but now we're in a new fiscal year and we don't want to clear out the SharePoint list, but we only want the dropdown to show items with a "Date" value of 8/31/19 or newer.

This is what I currently have set up, because I'm sorting alphabetically.

I've tried something like this:

Filter(
 Choices('Break & Educate'.Title), 
 Value in Filter('Date'>08/31/2019).Date
)

But that's just giving me an error. Any help on this? Luckily the list column names are pretty simple ("Title" and "Date"), but this is giving me a headache.

TIA for any advice you have.

Categories:

Building Power Apps