HI,
i want to display a SPList value into a gallery based on month and year selection in dropdown.
This is my collection,
ClearCollect(collMonths,{ID:1,Name:"Jan"});
Collect(collMonths,{ID:2,Name:"Feb"});
Collect(collMonths,{ID:3,Name:"Mar"});
Collect(collMonths,{ID:4,Name:"Apr"});
Collect(collMonths,{ID:5,Name:"May"});
Collect(collMonths,{ID:6,Name:"Jun"});
Collect(collMonths,{ID:7,Name:"Jul"});
Collect(collMonths,{ID:8,Name:"Aug"});
Collect(collMonths,{ID:9,Name:"Sep"});
Collect(collMonths,{ID:10,Name:"Oct"});
Collect(collMonths,{ID:11,Name:"Nov"});
Collect(collMonths,{ID:12,Name:"Dec"});
ClearCollect(collYears,{ID:1,Name:"2021"});
Collect(collYears,{ID:2,Name:"2022"});
Collect(collYears,{ID:3,Name:"2023"});
Collect(collYears,{ID:4,Name:"2024"});
Collect(collYears,{ID:5,Name:"2025"});
I loaded these collection into a two dropdown for month and year.
Now what my problem is i selected a month in dropdown it always return 1 in a month format.
This is what am using to get a value in gallery,
FirstN(SortByColumns(AddColumns(GroupBy(Filter(Kudos,Month(CreatedonDate) in Text(Month(Dropdown3.SelectedText.ID)), Year(CreatedonDate) in Dropdown6.Selected.Name),"CreatorName","CreatorEmail","Details"),"Count",CountRows(Details)),"Count",Descending),5)
But am getting always 1 in month format..
How to get correct month format by selecting dropdown?
Thanks,
Dhinesh
