Apply to each and an Array

(0) Share

Report

Posted on by zapatilla2004

Hi,

I've got a Apply to each to delete repeated items y an array but is not working, this give me all the items, why?

Not all the items are the same in all the fields, but I want to delete all that have the field Material repeated leaving just one.

2023-10-20 10_53_46-Window.jpg

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hola @zapatilla2004 !
There is a simple way to make sure your Filter array is working as expected, that is to add a 'compose' action block just adter it and add the following WDL expressions to count nr of elements from the SP list, and nr of elements after filtering
length(outputs('List_rows_present_in_a_table')?['body/value'])
length(body('Filter_array'))
Ánimo!
========

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Now, my suggestion to identify duplicated items is:
First, build a 'Dictionary' array with all possible 'Material' column values present in the Excel table, by means of a Select action block and WDL function union(). This technique is explained here:
https://powerusers.microsoft.com/t5/Building-Flows/Filtering-Unique-values/td-p/531930
Next, iterate over the Dictionary elements by means of an Apply to Each:
Inside the Apply to each, add a new 'Filter array', so you will obtain rows whose Material column value is the one from current iteration.
Now, if you need to store the first element in an 'output' array variable, you can append to your 'output array' variable the first element obtained by means of filtering by using first() WDL function
Hope this helps!
===========

Was this reply helpful? Yes No
zapatilla2004 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks!!! it works perfectly...

Was this reply helpful? Yes No