Showing results for 
Search instead for 
Did you mean: 
New Member

SharePoint Flow - Array Contains function

I could not find a Contains function for the Array variable type and I was wondering if someone could help.


Full Requirements:

I have 3 lists: Projects, Project Tasks, Actions.



- Title



- Title (Single Line of Text)

- Team 1 Actions (Multiple Lookup to Actions)

- Team 2 Actions (Multiple Lookup to Actions)

- Team 3 Actions (Multiple Lookup to Actions)


Project Tasks:

- Project

- Action (Lookup to Actions)

- Assigned To Team

- Due Date


I have a Flow that is run when a Project is created that creates items in Project Tasks based on the selected Team 1-3 Actions and assigns them accordingly. The problem I am running into is when the project manager wants to remove a task. I thought it would be as easy as:

1. Create an array of all Selected Tasks and store them in an Array variable called "Selected Tasks"

2. Query Project Tasks for all Tasks for that Project

3. For Each Project Task, if "Selected Tasks" does not contain the current Task, delete it


I could not find a "Contains" function for Arrays though. For that matter, I found many Array functions to be missing ("Remove from Array", "Pop", etc)

Community Support
Community Support

Re: SharePoint Flow - Array Contains function

Hi @heylookabird,


The Array functions that you mentioned is not supported in microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:


Best regards,


Helpful resources


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (8,233)