Hi
1) please always share what you tried, versus asking us to write it all for you, so that you can learn and we can understand what you are trying to do
2) You say merge them, merge them into what? I get that you want to merge them together, but for what purpose? into another Excel table, into a SharePoint list, or Dataverse Table?
I cannot tell you how to merge them, because I dont know what you mean by merge them but I can tell you how to start what you want and you fill in the blanks
1) Use List rows in a Table on List 1
2) Use an Apply to Each, with the input being the Dynamic Body/Value from Step 1
3) Inside the apply to each, use another List Rows, but add a filter for the email address that you are getting from List 1 in the Apply to Each current iteration to pull back the single row in List 2 with a top of 1
4) Add a Condition to verify that the List brought back a single row
In the yes side, do your work
--After this, I don't know what you mean by merge, do you want to add all the columns from list 2 to list 1? Do you want to create an entirely new list in another excel sheet?
Now you can merge them together
