Select from filter array // Excel // rows // not contains

[Anonymous]

I can filter the table with an external action "Filter Array": 

@And(not(equals(item()?['Project_x0020_Requestor_x0020_(OU)'], 'Materials North America')), not(equals(item()?['Project_x0020_Requestor_x0020_(OU)'], 'Materials Processing & Services North America')))

now how can i extract a column out of this filtered array/table into an array?
Like after filtering out project with the condition i mentioned now i get a reduced table and out of it i want to extract the column "Project Manager" to get their names into an array.

Trying the above mention method i get the following error:
The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

[Anonymous]

The problem is i cant filter at list rows with multiple criterias. So the 1st criteria is being done in "list rows" (Stage eq 'Running').

My 2nd filter is "not contains 'xyz'.

From the final result i want to extract all names of 2 columns called Project Manager and Responsible and put them into an array to work with.

So after progressing with the 2nd filter "not contains" with the action "filter array". How am i supposed to get the names out of these 2 columns of the resulting "array/table" of filter array?

[Haithamalsheikh]

try to make 2 filters

make a filter array after that insert compose for the first condition 

after that make a second filter array from compose of the previous filter.

then you can make select.

[Anonymous]

i dont get it.. the first filter is already done by listing the row - why take it out from it?
the only left filter is being worked on with "filter array".
So look up at my screenshot: actually the output of my filter array should be already in final form as i want.

my question: how to extract the 2 columns i want out of this filtered array? with select?

[Haithamalsheikh]

hi,

Try this solution:

1 - after you make a filter using that output for each

2 - insert select put your columns name on the left and on the right put the below expression and change *** with column names

item()?['*****']

the below is flow

[Anonymous]

In the Select action: should i really use "body" as "From" or current item of apply to each?

[Anonymous]

After doing so as i you described how do i get use of Select. E.g. a mapped column of Select into a String array