Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Haithamalsheikh 13 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Haithamalsheikh 13 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No