Power Platform Community Forum Thread Details

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.

Categories:

Using flows

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