Notifications
Announcements
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.
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!========
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/531930Next, 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 functionHope this helps!===========
Thanks!!! it works perfectly...
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 378 Super User 2025 Season 2
David_MA 273 Super User 2025 Season 2
Expiscornovus 135 Most Valuable Professional