Announcements
Hallo,
i want to display the 12 months as numbers in a dropdown so i can filter a gallery.
I dont want to use [1,2,3,4,5,6,7,8,9,10,11,12]
How can i do that?
@marial16
Set your Items property to: Sequence(12)
I hope this is helpful for you.
Still it is not recognized as Month
What do you mean by "not recognized as Month"?? You asked for the 12 month numbers - that would be what that formula will provide - 12 numbers.
Can you explain more of what you are trying to do and what problem you are having?
I have a gallery which i want to filter based on the year and month. The month will be selected from a dropdown (1-12).
gallery gets data from a list that has 2 columns ,Year (single line) , Month (date), ListID (number)
in the gallery items i use :
Filter(list, ListID = 1 And Year=Year(Today()) And Month = Dropdown.Selected.Value)....
Without the month query it works but when i try to add the Month=.. I am getting an error
I even tried add Columns
ClearCollect(myCollection,AddColumns(List,"MonthNumber",Month(Month)))
And use the "MonthNumber" to filter
Still did not work..Could it be that the Columns is Named 'Month' and there is a conflict of somehow..I am not sure
But you are stating that the Month column is a Date column...so trying to match that to a number is not going to work.
So if it is a date column, then your formula would be:
Filter(list, ListID = 1 And Year=Year(Today()) And Month = Date(Year(Today()), Dropdown.Selected.Value, 1))
No collection is needed for this!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 394 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 324 Most Valuable Professional
