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