I have a table with the members of my club. Each member should be able to view only his/her own data so I set up the slice [Email] = USEREMAIL(). However, I also need a view where the responsible for a club area can view all the club members of that area. I then created the slice [Responsible] = USEREMAIL() but it does not work. I had to create another table, identical to the first, with the same data, only for the purpose of creating the view for the area responsibles. Is there a way to manage those two slices with one table? Thank you to anyone who can help.
Creating a slice indeed governs only what data is displayed for view within an app–it does not govern what data is downloaded to a device and, therefore, accessible in other ways by the user. To preclude all access to certain data, use instead a security filter.
It doesn’t make sense that this slice row filter expression doesn’t work in your original table but does work in your new identical table. Something else is going on. You need to figure out what’s wrong with this expression. Maybe the [Responsible] column’s values aren’t actually email addresses?
Absolutely. That’s the purpose of slices.