Showif formula with custom users table formula failing

[chrismiller015]

I have the following expression for showif on my view:

SELECT(appsheet users[viewlevel], (appsheet users[email] = USEREMAIL())) > 1

it is failing with "Cannot compare list with email"

Context:

I created my own users table "Appsheet Users" and added a column "ViewLevel" with a value of 1, 2, 3, or 4. The goal is to restrict certain views based on a user's view level. I can user USERROLE()="Admin", but I would like a little more flexibility other than Admin & user is possible. 

In the appsheet users table, email is set as text. I'm hoping that someone can help me rewrite this formula? The way I've written it is to select the value of viewlevel for the user based on their useremail(), if that value is > 1 show the view

[Marc_Dillon]

SELECT returns a List.

https://help.appsheet.com/en/articles/2347632-any

[JuneCorpuz · Accepted solution]

1. Create a current user slice

2. Change the SHOW IF formula in your view with INDEX(Current User[ViewLevel], 1) > 1

[chrismiller015]

I had created the table already, but i was missing the slice, that plus using the INDEX formula did the trick. Thank you so much!