Power Platform Community Forum Thread Details

Power Apps Gallery Filtering Issue with Year

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.

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

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 me with the coding of the Gallery items property code I would appreciate it.

Also, off topic question, For some reason, The forum's UI changed and I don't have the option to reply to responses. is that a bug?

Categories:

Power Apps component framework

Power Platform Build Tools

With( { _Start: Date(Year(YourReferenceDate), 1, 1), _End: Date(Year(YourReferenceDate), 12, 31) }, Filter( 'Data Source', StartsWith( Title, SearchBar.Text ) && YourDateField >=_Start && YourDateField <= _End ) )

Quick Links

Leaderboard > Power Apps