Help with filtering data table based on person

[ezi79]

Hi 

I am trying to filter data table based on person column. 

I added a combobox (Person)and 

Display Field : I'm tring to set it to Display name but it reverting back to Result

Item :Distinct(' Power app PG',Name.DisplayName)

Filter('Power app PG', CBNameSearch.Selected.Result || Name =CBNameSearch.Selected.Result)

Name is my person column , I get incompatible type of comparison This type can not be compared Record/Text

Obviously I m doing something wrong here I can not find any example to show person filed in Combo box (from sharepoint list ) and filter by Person column . What is the best way of doing this?

Many thanks in advance 

[RandyHayes · Accepted solution]

@ezi79 

This is correct - when you use the Distinct function it returns a table with a single column called Result.  That will represent the results of what the function found as distinct.

The problem is in your filter statement as it is trying to compare a record to a string.  The record being Name.

So your formula should be:

   Filter('Power app PG', Name.DisplayName =CBNameSearch.Selected.Result)

I hope this is helpful for you.

[ezi79]

That's great thanks