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! Go to Solution.
That worked!!
SPLIT(ANY(SELECT(Users[Counties Allowed], [User Id]=USEREMAIL())), โ,โ)
Thank you
Phil
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |