Enum list from enum list

Hi,

I think this may have been covered before but I have a list of counties in an outlet app that a user can assign to themselves. The reason for this is that the security filter is used to only search the database in the counties that have selected. This means that the app is much faster as it doesnโ€™t search data that is not in the counties selected. These counties are made up of an enumlist of a column in my administrator table. I allow them to view certain counties and they in turn filter those one to only the data they want to see/search at that time.

This works fine. But I also have a map and list search funstion where they search outlets by type, rating and county. The enumlist is taken from the counties they have selected to assign themselves. As this is taken from an enumlist itself I end up with and enumlist of an enumlist.

Rather than a column being used it is the contents of a cell that shows this below for example.

Aberdeenshire , Avon , Berkshire , Cheshire , Cumbria , Dorset , East Sussex , Essex , Hampshire , Kent , Lancashire , London , Merseyside , Middlesex , Surrey , North Yorkshire , Somerset , West Sussex , West Yorkshire , Wiltshire , Shropshire

Is there a way I can turn the above into an enumlist

Thanks

Phil

Solved Solved
0 8 620
1 ACCEPTED SOLUTION

That worked!!

SPLIT(ANY(SELECT(Users[Counties Allowed], [User Id]=USEREMAIL())), โ€œ,โ€)

Thank you

Phil

View solution in original post

8 REPLIES 8
Top Labels in this Space