web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Merge Two Excel Files ...
Power Automate
Suggested Answer

Merge Two Excel Files into one by using the first column as key

(1) ShareShare
ReportReport
Posted on by 4

I have a flow which is getting different sets of data from two tables (which are stored into two different excel files) and I want
to merge the two into a single table by appending the data from the table in excel file 2 into the table into excel file 1. Both of
them have one common primary key which is unique (an e-mail adress).

 

I want combine both table into single table for each row return from the table in the second excel file, I tried with a for loop but could
not make it work.



Any solution on my problem here? Any help would be great. 


 


 
Categories:
I have the same question (1)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    Hi,
     
    May i know one thing here- like since it seems like join operation, what should we do for the rows in table1 which does not have same primary column value in table 2?- should we remove those rows ?
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard