Skip to main content

Notifications

Power Automate - Building Flows
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
 
  • trice602 Profile Picture
    trice602 11,657 on at
    Combining 2 sharepoint lists with same column header names
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard