Field visible to only few users

[djreyes1110]

Hello, how can I make a field only visible to 10 people? Do I need to create a contact list basing on their email address?

Thank you!

[zmorek]

That's one way to do it, and it's more manageable if that list of 10 people changes frequently (as opposed to hard-coding it into a formula). There's lots of ways to accomplish this!

Add the users to a list with their emails, then you can do something OnAppStart that sets a variable based on the current user:

If(CountRows(Filter(ListName, User().Email=EmailColumn))>0, Set(varVisible, true))

Then set the Visible property of that field equal to varVisible.

[djreyes1110]

Im getting an error. My formula is below:

!IsBlank(LookUp(AccessControl, Title = varuseremail).Title), Set(varuseremail), true))

Please help!

[zmorek · Accepted solution]

Try something like this instead:

If(!IsBlank(LookUp(AccessControl, Title = User().Email)), Set(varuseremail, true)

I'm assuming the Title column is where the user's email is stored? Watch your syntax, too; there's some parenthesis in the wrong spot.

[djreyes1110]

Thank you! 

I need to add this formula ONSTART right: If(!IsBlank(LookUp(AccessControl, Title = User().Email)), Set(varuseremail, true)

Then on the field that I would like to be visible to few people i need to add varuseremail under variable?

Which I did but still the field is still visible and theres no error message.

[djreyes1110]

I got it! Thank you! my variable had a problem!