Merge SharePoint Lists Flow

(0) Share

Report

Posted on by Phineas

4,976 Super User 2025 Season 1

I am trying to build a Merge lists flow - Client Data list and Client Address list.

I've created a filter array for each list. I've created a Send an HTTP request to SharePoint action.

I have an XML action, Create file action, and Create table action. Everything is working.

My issue, I still can't figure out how to merge the data.

When I put the Client Data filter array in the final Apply to each (3), and run the flow, I get an Excel spreadsheet with the Client Data.

If I put the Client Address filter array in the Apply to each (3) I get the address data.

It is unclear to me at what point does the data/is the data to merge? How do I combine the two arrays?

What am I missing?