Incompatible type table, text when trying to Filter based on person

[aleemj]

Hi,  I'm a newbie to PowerApps. Would really appreciate assistance with an Incompatible types for comparison: table, text

I have a SharePoint list (Work Assignment) that has a person/group column called 'Assigned To'

I am attempting to Filter a gallery to show items that are assigned to the logged in user only.

I have tried the following with the same result. 

Filter('Work Assignment', 'Assigned To' = User().FullName) and I have also tried:

Filter('Work Assignment', 'Assigned To'.DisplayName = User().FullName)

In both instances I receive the same Incompatible comparison type error. 

Please help as I am a little beyond my depth.

[Mike2500]

Is assigned to a multi value field? If so, that's quite a bit more complex, as the assigned to would then have a set of rows, not just a single person. Otherwise, your second example looks fine:

Filter('Work Assignment', 'Assigned To'.DisplayName = User().FullName)

[Jeff_Thorpe]

The AssignTo is a record, so you need to reference a column in the record. Try this:

Filter('Work Assignment', 'Assigned To'.Email = User().Email)

[aleemj]

Hi Mike, thanks for your super quick response. Yes the Assigned to field does allow multiple selections, I had a feeling this may be causing the issue. Any advice to overcome this would be appreciated.

[aleemj]

Thanks Jeff, I did try this to with the same same result. @Mike2500 in a separate reply has pointed to multiple values allowed in this field as the potential issue.

[Jeff_Thorpe · Accepted solution]

If the Assigned To column in SharePoint allows multiple selections then you could do this way but you will get a delegation warning because the "in" operator isn't delegable.

Filter('Work Assignment', User().Email in 'Assigned To'.Email )

[aleemj]

Thanks so much @Jeff_Thorpe , this works perfectly.