It is possible to configure enumlist Usersett...

[Arnaud_B]

It is possible to configure enumlist Usersettings() to filter many Year in a table ? If Yes, how to ?

[Levent_KULACOGL]

@Arnaud_B can you elaborate your question? What do you mean with " many Year in a table "?

[Arnaud_B]

A User settings that select many year (2016, 2017, 2018) or single Year 2016 … One Enumlist in usersettings …

I’ve try in condition of slices but doesn’t work: YEAR([Date]) = USERSETTINGS(Year_Option)

[Aleksi_Alkio]

You could use IN expresssion… like IN(YEAR([Date]),USERSETTINGS (Year_Option))

[Arnaud_B]

THX it work. One more expression problem to list YEAR Date

=SELECT(YEAR([My_Date]), TRUE) return that parameter 1 in YEAR function is invalid … and if i’ve many 2016 or 2017 or, … how to filter list to have just one entry of each

[Aleksi_Alkio]

Would you please describe your case little more… I didn’t understand the reques totally, sorry.

[Arnaud_B]

I’ve set a usersettings Enumlist with Year Date. I can now filter with the expression u give me.

But i need one app formula in my usersettings Enumlist field to list Year Date from my column.

But , if i have many same Year in my column, i don’t want to see

2016 2016 2016 2017 2017 2017 2017 2017 … on my button enumlist … U understand ?

[Aleksi_Alkio]

How about TableName[YearColumn]

[Arnaud_B]

@Aleksi_Alkio this expression in app formula to get list of Year ??? Mean it was =select(… to have a list ?

[Aleksi_Alkio]

TableName[YearColumn] is basiacally the same than SELECT(TableName[YearColumn],TRUE,TRUE). When you want it as a dropdown list, you need to type it into the Valid_If.

[Arnaud_B]

Thx ill try