Unanswered

Combining Sharepoint List

(0) Share

Report

Posted on by Community Power Pla...

I have 3 sharepoint lists with the same columns, I would like to combine them into one sharepoint list. How can I do this?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Anupam.khasia 366 on at

Like (0)

Report

Hi @Anonymous ,

You can not create a new sharepoint list directly using power automate Although you can combine data of these lists and add to existing other list. I am not sure these suffice your requirement . here are steps you can perform to combine data of 3 list.

1) Declare an Array Variable
2) Use Get Items action of SharePoint to retrieve your first list
3) User "Append to array variable" action and select Value (List of Items) from Dynamic Content
4) Use Get Items action of SharePoint to retrieve your second list
5) User "Append to array variable" action and select Value (List of Items) from Dynamic Content
6) Use Get Items action of SharePoint to retrieve your Third list
7) User "Append to array variable" action and select Value (List of Items) from Dynamic Content

Here your Array variable will hold data from 3 list and you can perform further operation on this Array.

If this helps you , please mark this as resolved.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Anonymous

While there is no "out of the box" Flow action that allows for you to create a new SharePoint list, you could get there via the SharePoint HTTP action. That said, it likely isn't worth is. You would be better off using another method such as that suggested by @anupam8555 . Other options include using MS Access - you could export one of the existing lists to a new list using Access, Then, you could quickly create append queries to append the data in the other two lists. This will take you only a couple of minutes if you are familiar with Access.

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@Anonymous if there aren't too many items in each list (or even if there are lots of items) go to Quick Edit in each of the first 2 lists and copy & paste into the Quick Edit on the combined list, just like you would with Excel.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Possibly a silly question, but now that I have the data from multiple lists put together in 1 array, how do I get the data from the array into a new list?

Was this reply helpful? Yes No
bobw53 9 on at

Like (0)

Report

How can you declare an array variable? I can't find anything online.

Was this reply helpful? Yes No
bobw53 9 on at

Like (0)

Report

This seems logical, but I can't get past the first step. How can you declare an array variable? I can't find anything online.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@bobw53

Take a look at this blog post - I believe it will get you started.

Was this reply helpful? Yes No
bobw53 9 on at

Like (0)

Report

Thanks @ScottShearer

Was this reply helpful? Yes No
B8 258 on at

Like (0)

Report

Can you explain in Automate how to write this.

1) Declare an Array Variable
2) Use Get Items action of SharePoint to retrieve your first list
3) User "Append to array variable" action and select Value (List of Items) from Dynamic Content
4) Use Get Items action of SharePoint to retrieve your second list
5) User "Append to array variable" action and select Value (List of Items) from Dynamic Content
6) Use Get Items action of SharePoint to retrieve your Third list
7) User "Append to array variable" action and select Value (List of Items) from Dynamic Content

i had created a sharepoint list which has all the column of 2 Sharepoint in one sharepoint list

1 people found this reply helpful.

Was this reply helpful? Yes No