Filter an array in a loop

[Frog64]

Hi,

I create two arrays in a flow:

1. ArrayTable with full data for every vendors present in my system: purchase order number, vendor account, item, quantity, email...
2. UniqueVendor: with the vendor accounts without duplicates

I want to create for each vendor present in the UniqueVendor's array, an array with his own records from the ArrayTable, and then send to him an email with his records.

I create two nested loops, but my filter is not good, so it fails:

I followed this post but it doesn't work: https://powerusers.microsoft.com/t5/Building-Flows/Iterating-over-distinct-or-grouped-by-column-valu...

My array UniqueVendor:

The array ArrayTable:

Here are my loop's issue:

I want to create a loop for each vendor (first loop), and then select all related records before sending an email to the vendor: you can see the results of the test, and then the setup of the flow:

When I send a message on Teams, I can check the data of the condition test: I can see that the second value is not good, because it should have been 00000021 only (not {"Vendor":"00000021"}

[tom_riha · Accepted solution]

Hello @Frog64 ,

instead of a loop inside a loop, try to use the 'Filter array' action:

• 'Apply to each' of the unique vendors
  • 'Filter array' from the second array, filter only results where Vendor (from the 2nd array) is equal to Vendor (from the 'Apply to each')
  • process the output from the filtered array, it'll contain only the items for given vendor

[Frog64]

Hi @tom_riha ,

I tried this:

ArrayTable is my table with all the data that I want to filter

But the result is empty: I suppose the fields or syntax are not good in my condition...

[tom_riha · Accepted solution]

The 'UniqueVendor' array is also an object, it doesn't contain just the number, but the whole object, e.g.

"Vendor": "00000503"

To get just the vendor number, you can't use the whole 'Current item' dynamic content, you should use only the 'Vendor' value from the object.

items('Apply_to_each')?['Vendor']

If you switch to 'Advanced mode' in the Filter Array, it should look like this:

@equals(item()?['Vendor'], items('Apply_to_each')?['Vendor'])

[Frog64]

Thanks for your help!