Power Apps Gallery Filtering Issue with Year

(0) Share

Report

Posted on by ShadowHeart

I want to filter a gallery based on year values from a SharePoint list. The SharePoint list has a calculated column called ProjectStart_Year that extracts and stores the year as a Date/Time (e.g., "2023"). I want to allow users to filter the gallery using a search bar (which already works as my code shows) and the year using a dropdown.

Code:

If(
    IsBlank(SearchBar.Text),
    'Data Source',  
    Filter('Data Source', StartsWith(Title, SearchBar.Text))
)

It's kind of tricky because I think the SP list column contains date and time by default and PowerApps can match the date when looking up a record but not a time.
If somebody could help, it would be great.

EDIT: I intend to use a dropdown to show the distinct years which the gallery should filter by

Categories:

Power Apps Pro Dev & ISV

All responses (1)

Answers (0)

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,

Could you try using the DateValue Function around the title By putting a Text function around it you could use it as a string.

But wouldnt it be easyer to use a DatePicker or a Dropdown for the year/ Month and Day?