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 : QIxNdGxqgDTPwlohJO/cr3
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 18 Mar 2022 02:19:29 by 7

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?

 

 

 

  • Paintballhearts Profile Picture
    7 on 19 Mar 2022 at 04:32:56
    Re: Creating a new workbook using data taken from the lookup of 2 files

    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!

    Row.jpg

  • Paintballhearts Profile Picture
    7 on 19 Mar 2022 at 04:31:33
    Re: Creating a new workbook using data taken from the lookup of 2 files

    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

  • ArchitectMadhan Profile Picture
    1,580 on 18 Mar 2022 at 08:13:52
    Re: Creating a new workbook using data taken from the lookup of 2 files

    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.

     

  • KvB1 Profile Picture
    1,596 on 18 Mar 2022 at 07:22:07
    Re: Creating a new workbook using data taken from the lookup of 2 files

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

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete