Forum Discussion
Check filtervalues based on USERPRINCIPALNAME()
Hi all, At this moment we add a field to our datasets with this declaration: UserMail = USERPRINCIPALNAME() And we also add the mailadress of the people that are responsible for a dep...
In this scenario, you can define two roles in Row Level Security . One for those "general users" and apply dynamic row level filter on this table based on USERNAME(). The other one is for that "super user" without any row level filter.
Regards,
Yes I know I can do that. But for the superusers I also want their own department to be to only one to be displayed default. The other departments must be available in data, but not displayed when opening the dashboard....