Unanswered

Compare SharePoint list to array

(0) Share

Report

Posted on by jsangerman

I'm building a list of people in an array, comparing it to an existing list of people in a SharePoint list, then adding any missing people to the SharePoint list and updating the list record for any people that are not in the new array.

So far, I have run through each item in the array and used Get Items with a query filter to find matches. Anything array items without a matching list record were added to the list. Easy.

However, I'm having a hard time finding the people in the SharePoinst list that are not in the array. I could easily do nested loops, but that's not very efficient. I've tried using Filter Array, but I must not have the proper syntax.

When I run that, the filtered array always comes back empty. Why is that?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ellis Karim 12,203 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If I have understood the issue correctly, your flow could be simplified as:

The Get Items action should include a filter query. The Current item will refer to the current item of the array:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
jsangerman 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Ellis.

That's actually exactly what I did in the first part. That tells me which items in my array don't have a match in the SharePoint list.

I'm having trouble doing the reverse: Figuring out which items in my SharePoint list don't have a match in the array.

Was this reply helpful? Yes No
Ellis Karim 12,203 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hmmm. This reverse logic can make my head hurt this late in the day.

Try this test:
In this version the Get Items action does not contain a filter query:
List of items where the ApproverName (or Title in your flow) are not found in the People array
List of items where the ApproverName (or Title in your flow) are found in the People array

If I have understood the question correctly, I hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No