You’re offline. This is a read only version of the page.
Hello,
I'm quite new to Power Automate and was hoping someone could help.
So here is what I am doing. I am taking in responses from user through Microsoft Forms and this data is getting stored on my One Drive Excel sheet. So I have 2 different forms (which will give me 2 different excel sheets).
I want to merge these 2 excel sheets automatically based on their "ID".
The trigger can be as a repetitive process that happens every 3 hours once or anything other than manual trigger.
Lets call this as Sheet A (contains 10 columns), which has a Column "ID" that is unique.
Sheet A
Lets call this Sheet B (contains 5 columns), which also has Column "ID" which has the same values as Sheet A.
Sheet B
I want a merged sheet that adds data onto the 3rd sheet only when the value of "ID" in Sheet A = Sheet B.
If this condition is true then the entire Row of Sheet A and Sheet B should be added to Sheet C (The merged excel sheet) in a single row.
Sheet C would be containing totally 15 Columns (10 from Sheet A and 5 from Sheet B)
Thank you in advance!
Thank you for your timely reply @v-bofeng-msft, your given solution worked perfectly well for my flow.
Cheers,
Siddharth
Hi @Sid26 ,
I've made a test for your reference:
1\My tables
2\My flow
3\The Result
Best Regards,
Bof
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (