Unanswered

Problems with Creating Flow - Filter Array Step

(0) Share

Report

Posted on by karlosmui

I am somewhat new to creating flows and it seems like I can only be successful when I create the data from a MS Form - basically I am trying to take an excel file (which is an export from my ERP AQL Table) and use the data, but I seem to always run into problems. One I am trying to do basically compares an employee roster to a list of employee numbers punched into the system. I have it set as:

Recurrence
List Rows Present in a Table

Create CSV Table

List Rows Present in a Table 1

Create CSV Table 1

Filter Array - from item()?['body'] - then taking the dynamic output from Table 1, does not include - I cannot get a list to come out no matter what I try and what I do.

Any help would be appreciated. Below are examples of the errors I receive in the step. I have tried to add a parse json step but this has not suceeded either

BadRequest

The 'from' property value in the 'query' action inputs is of type 'Object'. The value must be an array.

InvalidTemplate

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(item()?['Days'],30)' failed: 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,874 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Why don't you filter before you create your CSV table 1?

In that case you can use the body of the list rows in the from field of the Filter Array.

Was this reply helpful? Yes No
karlosmui 9 on at

Like (0)

Report
Copy link

Link copied!

I want to compare CSV Table 1 to CSV Table for "does not contain" on a common field and either get that it is not an array or another similar error. In either case if I get data to pass through the filter array step, it is complete data of either of the CSV Tables.

Was this reply helpful? Yes No
Expiscornovus 33,874 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Can you share a screenshot of that configuration?

Btw, have you tried using the except approach from this blog from Damien Bird in your Filter Array, that might be a could start for this comparison:

https://damobird365.com/efficien-union-except-and-intersect-great-method/

Was this reply helpful? Yes No
karlosmui 9 on at

Like (0)

Report
Copy link

Link copied!

So my dataset is larger than the table he references - in his intersect he claims he is using a select function, but my select wants a map - his looks exactly like filter array. I also cannot just reference output, because I have multiple column names in the data and multiple steps to contend with. My data in the csv tables is the correct and expected data. So I am looking for the function to take the emp_num field present in CSV Table 1 and return the results that are not present in Table 1 but are present in table.

Have tried to do:

Outputs('Create_CSV_Table')?['body']

item()?['emp_num']

body('Create_CSV_Table')

Like I said, it comes back with errors becuase the input is not an array - but the body should be an array "BadRequest
The 'from' property value in the 'query' action inputs is of type 'String'. The value must be an array.

Was this reply helpful? Yes No
karlosmui 9 on at

Like (0)

Report
Copy link

Link copied!

Ok, I scratched the flow and started again using this page as a template:

https://damobird365.com/efficiently-filter-a-json-object-in-power-automate/

So now in the filter array step, I can switch the data around but nothing ever gets filtered. Here are the filter array inputs:

From: body('Select_1')

then - body('Select') "Does not contain" outputs('Select_1')?['emp_num']

Asking it to return anywhere the emp num column doesn't have the data from select 1 in it but regardless it returns all records.

Was this reply helpful? Yes No