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
