
Announcements
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
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
Any help would be appreciated
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