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!
@v-litu-msft
@eliotcole
@VJR
