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?
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!
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
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.
Does the file have to contain a table with columns etc, or would a csv be enough?