Power Platform Community Forum Thread Details

Hello all,

I am stuck with the following requirements. I have 2 SharePoint lists, and the columns contain a person column, named, PersonColumnList1 & PersonColumnList2

I'm trying to avoid using an apply to each, and instead using a select action

This is what I am doing sucessfully:

Get Items SPList1

Select
And mapping UserC : with the following in the expression:

if(empty(item()?['PersonColumnList1']), item()?['Title'], item()?['PersonColumnList1'])

Then I have another Select 2

using the Output from Select

Map UserC: Expression: item()?['UserC']?['DisplayName']

This works and I can see all the users I am trying to obtain in an array:[
  {
    "UserC": "Joe Bloggs"
  },
  {
    "UserC": "Tom Smith"
  },
  {

etc
 
I then have a Get Items for my 2nd sp list

and when I use a filter array and From: value from the get items 2nd sp list, value is item()?['PersonColumnList2']?['DisplayName'] contains outputs('Select_2')

and its here the flow fails:

InvalidTemplate. The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(item()?['PersonColumnList2']?['DisplayName'], outputs('Select_2'))' failed: 'The template language function 'contains' expects parameters of matching types: a dictionary and a key (string), an array and a value (object), or a string and a substring. The provided types 'String' and 'Object' are incompatible.

Not sure, what I need to do and need help