On a column’s show_if constraint, I have the following expression:
ISNOTBLANK(INTERSECT( LIST("Supervisor","Manager"),SPLIT(Me[Position], ", ") ))
“Me[Position]” is a slice of a Users table that returns only one row (the current user) and the column returned is an EnumList.
Intended behavior is to return TRUE (show column on form) if the current user has “Supervisor” and/or “Manager” in their Position column.
The Test Table Data returns TRUE but yet no field is displayed. Have this problem on multiple columns in multiple apps now, when I could have sworn it worked before (dont hold me to that, I’m still a noob).
Removing the expression or using a simpler true/false statement shows the column as intended (so its not a column order setting on a view at least).
SPLIT(Me[Position], ", "))),
works as intended when used as a security filter within the same app. I had no luck by similarly-wrapping the first expression in an If statement.