Drop down not showing choices for Gallery (connected to sharepoint list)

[Mikehrod89]

Hello all 

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?

Thanks in advance!

[JanTHE · Accepted solution]

Hi @Mikehrod89 

I believe the syntax for your formula is wrong. 

Please try with comma, which would be

Distinct('Lab Request' , Creation Year)

instead of

Distinct('Lab Request'.Creation Year).

Hope that solves your query.

For the official documentation, you may refer to https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-distinct.

Cheers!