Power automate to group many Sharepoint Lists

(1) Share

Report

Posted on by dalila

Hello,

Can you please give advises on how to merge many (7) Sharepoints Lists within same columns into another sharepoint list with the same columns too.

The columns are : Customer account, Customer name, month, Sales representative (person), Value 1, Value 2, ....etc.

where each sale representative has a related list with only his portfolio customers, and we need to get a global sharepoint list at any value1, value 2 ,... update.

Thanks in advance.

All responses (1)

Answers (0)

FLMike 30,517 on at

Like (0)

Report

Re: Power automate to group many Sharepoint Lists

HI @Nourinssaf

You have 7 SharePoint Lists. You want to merge them all into 1 list.

1) How many rows are there?

2) are these all part of the same site??

If #1 is low, and #2 is true, then just create a new List, based on any of the other existing lists, since they are the same you said.

Click +

New List

From Exist

Select one of the existing

Now that you have the list

1) put the new list in Edit in Grid Mode

2) Go through each list, put them in Grid Mode

Bulk copy and paste them into the new list

and

Done

If you need code for sure for some reason please come back.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey