Help user to find their support

[Anonymous]

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 · Accepted solution]

@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.

[lbendlin]

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.