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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to send excel (fi...
Power Automate
Unanswered

Flow to send excel (filtered from information gathered 2 others files ) as attachment

(0) ShareShare
ReportReport
Posted on by 85

Hello all!

 

I developed a flow and I´m stuck... I can´t filter the excel information as it gets the "Apply each" and bugs everything.

 

The idea: There is a form on SP wich one only field: "CNPJ". When submiting it will start flow (When an item is created trigger).

This flow would do the following steps:

 

1) Gets the CNPJ information

2) Gets the EXCEL file 1 and filter the file with the CNPJ information.

Imput: CNPJ from form; Output: Vendor and E-mail;

3) With the output, it will get the EXCEL file 2 and filter the file with the output to get the associated invoice information that is on this excel files (There is 200+ differents vendor and 10k excel lines...)

Imput: Vendor and E-mail; Output: Associated rows

4) Convert the rows on a new file

5) Send an email with the information gathered on step 2 with the excel from step 4 as an attachment.

 

The problem is that I can´t filter step 3 due to error with apply each. I do can create the flow iwthout the filter (as per image on first link below) but can´t with filter.

 

Can someone do the steps above so I can see where I´m failing? 

 

Here are the images from my flow (I cant add as image due to forum error)
https://a6ro5g.by.files.1drv.com/y4p613QStG4e3obHRrA6WsHbn5n9SC89-SASufifZKv1P6AZ4MyL5SQYwebHdnUfFih_YZAmxJffX7wq8kVS7DeQhM_ffnN-XzGhqr12138CNtaip0YSfB3y0rI5NVBAFWAUZUhYq5DuucOFJVOhuT7t_XCmWbdevbPcy_K9K1ODT0yQLD6XM71FeozW3wnqdUdlZwwgUON0DBE0vAsj_8dX7_CG1RlILQHhqWbKLvRHfk/1.png?psid=1

 

https://adxoqw.by.files.1drv.com/y4plimsZGBNuS98_BOAydi9xWjm36jc8-ChadPL9yXeck45dw2mkjSZ3m7RbwYKfx9GDqXBVka-2UkP7yfdbRnFkio8VoQTDBH7DdlNpyv0208SS2SX0Wo-TgMYa8eitxljSJRrK1CPQ4iJ9IQC3nQZzqxeRajlTGOKCkfzibigZ_icKmiFJJKGV3vyvSaL9yxzgG5IgSpERe0JHF3K0lJGmCi36r33deYkCd8v9mVic5M/2.png?psid=1

Categories:
I have the same question (0)
  • v-alzhan-msft Profile Picture
    on at
    Re: Flow to send excel (filtered from information gathered 2 others files ) as attachment

    Hi @Lucas_Goncalves ,

     

    Sorry for the link that you provided couldn't be opened.

    If you has added a Filter Array action in the flow, you need to get the dynamic content or add expression for the Filter array action instead of the list rows present in a table action.

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Lucas_Goncalves Profile Picture
    85 on at
    Re: Flow to send excel (filtered from information gathered 2 others files ) as attachment

    Hello @v-alzhan-msft Alice!

     

    I could not understand your example... can you explain with a step by step on how would you do to get the final results I wish to get?

     

    Below are images (I don´t know how to upload to be seen here):

    https://www.dropbox.com/s/qrkbeg6k36xphrr/Esbo%C3%A7o.png?dl=0

     

    https://www.dropbox.com/s/x6jty4l2c647zns/Esbo%C3%A7o2.png?dl=0

     

    https://www.dropbox.com/s/6g7r5qmqdzckupp/Esbo%C3%A7o3.png?dl=0

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard