Can't filter out excel table using another excel table from previous step

(0) Share

Report

Posted on by marcgiag

Good morning… I am stuck on a project

I have 2 EXCEL Tables

Table 1 has a ID column, Name and Email Addresses (👍 I am able to get “List Rows Present in a Table” from this table)

Table 2 also has an ID Column with multiple rows with the ID

My goal is to Apply to each from table 1
Capture all records from table 2 where the Vendor ID = Vendor ID <--- this is failing 👎

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['Vendor']' is of type 'String'. The result must be a valid array.

After I get past B I will

Create a html table
Send email

Any help would be appreciated

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @marcgiag ,

Do you want to get the records in Table 2 where the value of the Vendor ID column is contained in the Vendor ID column in Table 1?

I have made a test for your reference.
1. Here are my Tables.
2. Here is my Flow.
union(variables('VendorIDArray'),variables('VendorIDArray'))
items('Apply_to_each_2')
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No