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 just opens the pBI and the system recognizes the UPN (Email) and then shows related to the city which support is available.
any ideas are welcome?
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.
2 Replies
- lbendlin
Super User
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.
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.
