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:
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.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.