cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:

pic2.png

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?

 

 

2 REPLIES 2
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

@RussellGove 

 

Please try this:

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

Snipaste_2020-02-05_20-00-45.png

Sik

 

Helpful resources

Announcements
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.

secondImage

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 (13,474)