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

Re: Get list of users who are not present in a list

@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?

Highlighted
Community Support
Community Support

Re: Get list of users who are not present in a list

@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!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (10,667)