Power Platform Community Forum Thread Details

Hi all,

I have a column in a SP list called 'Personnel_Name' that is a person/group look up column. In PowerApps I have embedded a BI tile that I would like to dynamically filter based on the selected individual in my 'Gallery_Resourcing' gallery. Each person may have multiple rows in the SP list based on the different projects they may be working on. For example:

Personnel_Name	Project Title	Hours/Week
Person 1	Project 2	12
Person 1	Project 1	2
Person 1	Project 3	10

The gallery items are set to: Sort(Distinct([SP List], Personnel_Name),Result.DisplayName).

The Power BI Tile URL is set to: "......&filter=SP List/Personnel_Name eq '"& Gallery_Resourcing.Selected.Result.DisplayName &"'"

However, this doesn't filter the tile as required. Any help would be appreciated!

Categories:

Building Power Apps

Hi @Anonymous ,

Does your Power BI report connect to your SP List?

Do you want to filter results that appear in your Power BI tile based on the Person type column?

If you want to filter results that appear in your Power BI tile based on the Person type column, I afraid that there is no way to achieve your needs. Currently, there are some known limits within filter in Power BI Tile control, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile#pass-a-parameter

The Field type used in your Power BI Tile filter must be a String, currently, complex type field (e.g. Person, Choice, LookUp, ...) is not available/supported as filter column in Power BI Tile control.

As an alternative solution, you could consider create a Text type field in your SP List to store the person name, then you could use the Text field column as filter column in your Power BI Tile control.

Regards,