Unanswered

Creating a new workbook using data taken from the lookup of 2 files

(0) Share

Report

Posted on by Paintballhearts

Hello, I created a flow to compare 2 workbooks and lookup the items which are not existing in the other workbook. I followed this flow to do it https://www.google.com/amp/s/sharepains.com/2020/11/11/compare-2-excel-files-power-automate/amp/

I now need the result to be put in an output file which shows the all of the data (rows and columns) not found in the file to be generated in an excel

Basically the flow is simply looking up values not found in the other file then filtering them out to create a new file

Is there anyone who can assist me to build this flow?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

Does the file have to contain a table with columns etc, or would a csv be enough?

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi @Paintballhearts,

Seems like comparison of two excel sheets you have already accomplished, now you are looking to store the output result in another (3rd) excel sheet dynamically from Power Automate.

For your scenario, to create the excel sheet dynamically and fill in values, please go thru the steps in this link.

Was this reply helpful? Yes No
Paintballhearts 7 on at

Like (0)

Report
Copy link

Link copied!

Hi @KvB1 it has to be a table format. Basically the thought is it lookups a certain row from the other table and if it doesn't contain that, all those rows should be created in a new excel file

Was this reply helpful? Yes No
Paintballhearts 7 on at

Like (0)

Report
Copy link

Link copied!

Thanks @ArchitectMadhan I did follow what you have suggested to check step by step however I'm now confused on what to put on the rows part given it should reference the results from the select action part.

Would appreciate the assistance!

Was this reply helpful? Yes No