Show_If UX view help

I am trying to limit which users can see certain views. I created a slice and I want to limit which user can see it from the menu view. I went into the view settings for the slice in the UX area and I was trying to use the show_if field but when I try to put a column name in for the table it is referencing it tells me the column can’t be found. The statement I am using is USEREMAIL()=[column_name]. Thank you for the help.

0 3 424
  • UX
3 REPLIES 3

Steve
Platinum 4
Platinum 4

The Show if for views are not evaluated in the context of any particular row, so you cannot reference columns directly. Instead, you’ll have to use LOOKUP(), SELECT(), FILTER() or the like to query column values.

Is [column_name] a reference to a column in the slice?

See also: FILTER(), LOOKUP(), SELECT()

I was able to get it to work by using this IN(USEREMAIL(),Tablename[Columnname]). Now it is all working great!

I have used to limit view simply by an OR expression ,
OR(useremail()=“xy@somemail.com”,useremail()=“abc@somemail.com”)

Top Labels in this Space