Showing results for 
Search instead for 
Did you mean: 
Kudo Kingpin
Kudo Kingpin

Get list of users who are not present in a list

Hi ,

I have an app that can assign tasks to users. It has two lists:

1.GlobalTaskAssignees is a sharepoint list that has a column called Assignee of type Person or Group. This list contains all the people that tasks CAN be assigned to.

2.Tasks is a sharepoint list that has the assigned tasks. It also has a column called Assignee of type Person or Group. This list contains all the tasks that have been assigned.


I need to get a list of people in GlobalTaskAssignees that do not have a record in Tasks.


It Seems this should work:

Filter(GlobalTaskAssignees,Not(Assignee in Tasks.Assignee))


But it gives me the following errors:

When hovering over the first Assignee variable I see this:


When hovering over Tasks.Assignee is see this:


Both the columns are set up the same, but it keeps giving me that error 'Invalid Argument type. Expecting a record value, but of a different schema.


Any ideas whats going on here?



Super User III
Super User III

@RussellGove ,

Is your issue here is that Not (or <>) is not delegable, neither is In ?

I just noticed your level, so I guess I do not need to explain this to you.

The one thing I can think of is that Assignee is a Person/Group type whereas Tasks.Assignee might be text?

Community Support
Community Support



Please try this:

Filter(AddColumns(GlobalTaskAssignees,"GTAName",Assignee.DisplayName), Not(GTAName in AddColumns(Tasks,"TName",Assignee.DisplayName).TName))




Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,930)