Filter an array in a loop

(0) Share

Report

Posted on by ConsultantIT

110

Hi,

I create two arrays in a flow:

ArrayTable with full data for every vendors present in my system: purchase order number, vendor account, item, quantity, email...
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-values-CDS-in-a/m-p/414778#M47718

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"}

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Re: Filter an array in a loop

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

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (0)

Report

Re: Filter an array in a loop

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...

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Re: Filter an array in a loop

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'])

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (1)

Report

Re: Filter an array in a loop

Thanks for your help!

Was this reply helpful? Yes No