Forum Discussion
Help user to find their support
I have two lists ListEmails: Email/city/country ListSupport: Email/city/support1/support2 All people from List2 are in List1 -but not the other way. The foreseen behaviour is that the user ju...
Anonymous
You can first create a relationship between List 1 email column and list 2 email column, then create an dynamic RLS group based on the username using the list with all username.
List1[Email] = USERPRINCIPALNAME()
Final step is publish to Service and assgin users to this RLS group on PBI Service after publish.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How are you showing this information? In a card visual?
You should be able to create a calculated column that uses the USERPRINCIPALNAME() to look up either email address.