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 / Combining 2 sharepoint...
Power Automate
Unanswered

Combining 2 sharepoint lists with same column header names

(1) ShareShare
ReportReport
Posted on by
Subject:  Combining 2 sharepoint lists with same column header names but distinct entries into a single HTML file in Power automate
 
Hello,
I have been trying merge multiple sharepoint lists that share the same column header names but are distinct sharepoint lists that act as data collection records for different departments, I have been trying to get a flow created using loop function but have never succesfully got a final output:
 
Attached file is how I want the output to look like:
 
The OOS type is the column that covers different work areas , any help in this regard would be helpful
 
Categories:
I have the same question (0)
  • trice602 Profile Picture
    15,332 Super User 2025 Season 2 on at
    Hi,
     
    I haven't tried this specifically, but this looks pretty good.  Check this out!
     

    Steps to Combine Two Lists in Power Automate

    1. Initialize Two Arrays:

      • Use the "Initialize variable" action to create two array variables (Array1 and Array2).
      • Populate each array with the respective list data. If the lists are dynamic (e.g., from a SharePoint list or SQL query), use the appropriate actions to retrieve the data.

      Example for Array1:

       
      [
      { "Column1": "Value1A", "Column2": "Value1B" },
      { "Column1": "Value2A", "Column2": "Value2B" }
      ]

      Example for Array2:

       
      [
      { "Column1": "Value3A", "Column2": "Value3B" },
      { "Column1": "Value4A", "Column2": "Value4B" }
      ]
    2. Initialize a Combined Array Variable:

      • Add another "Initialize variable" action to create an array variable (CombinedArray).
      • Set the type to Array and leave the value blank.
    3. Append the First Array:

      • Use the "Append to array variable" action to append Array1 to CombinedArray.
    4. Append the Second Array:

      • Use another "Append to array variable" action to append Array2 to CombinedArray.
    5. Output the Combined Array:

      • Use the "Compose" action or another action (e.g., create an Excel file, update a SharePoint list) to use the CombinedArray for further processing.

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

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 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard