You’re offline. This is a read only version of the page.
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.
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
In the Select action: should i really use "body" as "From" or current item of apply to each?
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
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?
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.
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?
#1
WarrenBelz
146,522
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,890
Most Valuable Professional
Share
Report
All responses (
Answers (
