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

[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

1. My goal is to Apply to each from table 1
2. 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

1. Create a html table
2. Send email

Any help would be appreciated

[v-yujincui-msft · Accepted solution]

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