Forum Discussion
Row Level Security | Userprincipalname() for Guest Account
Have found my fail, just had wrong RLS Formula. "Userprincipalname()" instead of Userprincipalname() 😕
Anyway it's hard to understand where the "right" Userprincipalname() in Dataverse is saved or whether theres another name not saved in Dataverse.
Hi P3Sven
What I have done in the past is to have both versions of the email/UPN in the RLS that way which ever one gets passed still works?
Hi GilbertQ ,
I've created RLS Role with 3 options out of systemuser dataverse table:
- dominname (normaly = USERPRINCIPALNAME(), but for Guest Account something with #EXT)
- internalemail (just the normal emailadress)
- custom mail (Custom added column with mail# + email, cause its not in systemuser dataverse table available, but is showing in Power BI as USERPRINCIPALNAME())
Unfortunately my custom email column is not working although USERPRINCIPALNAME () is showing exactly the same and should be filtered in RLS.
BR,
Sven
Have found my fail, just had wrong RLS Formula. "Userprincipalname()" instead of Userprincipalname() 😕
Anyway it's hard to understand where the "right" Userprincipalname() in Dataverse is saved or whether theres another name not saved in Dataverse.
Hi,
Glad to hear that you have solved your problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
