Show_If expression for column and user settings...

[Pelaton73]

Hi, I'm trying to filter a column, to get a result where "[Visible to]= usersettings(Name)", but whatever formula I try, SELECT(), CONTAINS(), FILTER() I always get the same result: Cannot appears List with Text in....
Where am I wrong?
Could anyone help me?

[jyothis_m]

What is the column Type of [Visible to]

if its Enumlist then try CONTAINS([Visible to],Usersettings("Name"))

[Markus_Malessa]

Either your [Visible to] or usersettings(Name) returns a list and the other returns text. I can't tell by the information you provided. Furthermore, usersettings(name) does not appear to follow correct syntax within Appsheet, is it actually usersettings[name]? Is usersettings the integrated user settings or is this your own datasource for user settings? Some additional observations, using a name might not be the best idea if you are trying to establish security protocols within the app, instead use emails and USEREMAIL() function. If you filter your datasource for users then [Visible to] = ANY(usersettings[name]) should be an option or IN(ANY(usersettings[name]), [Visible to]). Again this is highly dependent on your actual setup.