web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Can't filter out excel...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 92

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)

marcgiag_0-1652882886673.png

 

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

marcgiag_1-1652882886679.png

 

  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.

 

marcgiag_2-1652883220656.png

 

After I get past B I will

  1. Create a html table
  2. Send email

Any help would be appreciated

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    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.

    vyujincuimsft_0-1653030093163.png

    vyujincuimsft_2-1653030994950.png

    2. Here is my Flow.

    union(variables('VendorIDArray'),variables('VendorIDArray'))
    items('Apply_to_each_2')

    vyujincuimsft_3-1653032214962.png

    vyujincuimsft_4-1653032334765.png

    vyujincuimsft_5-1653032544561.pngvyujincuimsft_6-1653032693726.png

    Result Screenshot:

    vyujincuimsft_7-1653032786506.png

     

     

    Best Regards,
    Charlie Choi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard