Power Platform Community Forum Thread Details

Hi,

I have Sharepoint list with a few fields, and i use my app to populate it. One of the columns is a people column where I assign cases to a user. From this list i have created a PowerBI report.

In this app user can see all the cases assigned to him in a datatable connected to the sp list and it is filtered by logged on user.

I want to do the same for the PBI tile but I can't figure out how I can filter it by the logged on user, so he can see only his own cases and status on it.

One of the columns in pbi report/dataset is Behandletav.EMail which shows the users email.

I tried it like this, but it didnt work = "https://app.powerbi.com/embed?dashboardId=865d1418-e34a-4b2a-970b-c7d5349f1c00&tileId=5fe4f57a-0f9b-443c-a7a5-bf7a1339ecba&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVdFU1QtRVVST1BFLUUtUFJJTUFSWS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsibW9kZXJuRW1iZWQiOmZhbHNlfX0%3d &$filter=Behandletav.EMail"& varUser

One of the filters for my sp dataset in powerapps also is by email, the variable is Set(varUser, User().Email);

Do I have to add the filter to TileUrl and how would I write it?

Categories:

Building Power Apps