Drop down not showing choices for Gallery (connected to sharepoint list)
I'm creating an app to track the requisitions for an specific department. This app is linked to sharepoint list. I have a gallery that I want to filter using a drop down box but I don't know why its not showing the choices.
The formula I'm using for the drop down box is: Distinct('Lab Request'.Creation Year) "Lab request" is the name of the gallery & sharepoint list while "creation Year" is the column I want to filter.
I have made this kind of filter with other drop down boxes and they are working in edit mode
I dont know why the filter for the creation year is the only one not working even in edit mode. I think this is something very simple, can someone help?