Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    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 at
    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 at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492