Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Matching items in an array to a column

I don't have a Flow that even attempts this yet but I have a case where this is needed.

I have a list with each door being a column(Single Line of Test) for simplicity lets say Door1 Door2 Door3

I have an array of Door that the user has requested.

Say Door 1, Door 3

What I want is for the Array to put a Yes in the column that matches Door 1 and Door 3 for the user.

I have over 30 doors to do this on can this be done in Flow?  

Please help



Solution Sage
Solution Sage

Re: Matching items in an array to a column

Hi @jkeckard007 ,

As your discription, you have a list with some columns.

And the columns name is like: Door1, Door2,Door3.....

When the user raise a request with an array like:[Door1,Door3].

Then set the value of the two columns to 'Yes'.

I am afraid that there is no way to achieve your needs in Microsoft Flow currently.

There is no actions to get the column name of SP list.

The flow can only get the column value.

And in the Flow, there is no way to monitor the specific column.

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

Or you can vote the similar idea below:

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




Helpful resources


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


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 Solution Authors
Users online (10,171)