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.