Power Automate Flow - Copy List info in Site Collection Sites

Dominic Moss

I am admininstering Project Web App and we have a site collection of many sites, all created using the same template. The sites have custom lists for Risks, Issues, Actions, Decisions.

I want to consolidate all the information for each of these lists into a single list, for example, the risk lists in each of 180+ sites to be copied to a single list. The Issues list in each of 180+ sites to be copied to a single list etc.

I have created a Flow that sneds an HTTP request to SharePoint and results in a list of 181 sites being rendered but I don't know what to do next to get to my desired outcome.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
You can do this by using Power Automate.

- get all sites
- get list items
- copy into list

Copy items
https://normyoung.ca/2020/10/01/use-power-automate-to-move-microsoft-lists-items-to-another-list/

Get subsites and looping
https://powerusers.microsoft.com/t5/Building-Flows/Loop-through-all-subsites-in-Site-Collection/td-p/784205
+3
Dominic Moss5y ago
I am new to this forum so not sure if this is correct - thanks for your suggestion Vaibav, I am going to see if I can get it to work.
+1
Vaibhav Chauhan5y ago
Hi,

you need to run a loop on every site you got as a result and fetch lists of that site using SharePoint rest api.

Again apply loop on lists and filter your source lists using conditions and fetch the list items of source lists and add that items in your target list using SharePoint Add item action/ SharePoint rest api.
+2