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?
