How to Filter / Sort Gallery

[Jean_9681]

I am building a Power App that will fetch data from a SharePoint list.

Columns in SharePoint list

Project Name - Lookup Column 
Year - Choice column
Month - Choice column
Billable hours - Single line of text (only numbers used)

I would like to filter the gallery and show the following values

Year	Project Name	This Month	Last 3 months	Last 6  months
2022	ABC	02.00	31.05	62 .05

Ex:
Sep - 10.00 hrs
Oct - 11.00 hrs
Nov - 10.05 hrs

Dec - 02:00 hrs
---

I am not sure if this is doable with the current column setup.  I need some suggestions on this.

Thank you, 

[Chitrakant27]

Hi @Jean_9681 ,

Take a one dropdown and in item property of dropdown code - Choices[@d_sourcename].Year)

and apply below code in item property of gallery

SortbycolumnFilter(D_Sourcename,Startwith(Year,dropdown.selected.value)),'ID',Descending) 

If you share some screen short that will be better if code not run

Thanks,

Chitrakant27