Forum Discussion
Historic RAG
Thanks Paul_Mather this does get close, but the information we want to collate is from the lists (same format) on the various project sites that sit are basically subsites to the PWA.
Is there a flow that will extract the same fields from these lists and copy them to another list?
Thanks!
Hi pauleast ,
You will find Flow samples either in blogs posts or as templates that will get you so far but you will need to build this flow - for example some of this Flow would be applicable: https://pwmather.wordpress.com/2019/07/11/projectonline-risk-to-issue-escalator-built-using-microsoftflow-office365-sharepoint-javascript-ppm-projectmanagement-msproject-pmot-pmo/
as this reads a list item and creates a new list item using some of the data from the original list item. This article also includes something similar: https://support.microsoft.com/en-gb/help/4467880/how-to-copy-items-between-two-sharepoint-lists-by-using-flow
Hope that helps
Paul
Thanks Paul_Mather - really helpful. One question is there a way to gather from multiple lists into one list? The lists all sit on the individual project sites. I am trying to find a way round the fact that the PowerBI content pack for PWA only draws from native fields, not custom one.
Thanks again!
Paul
Hi pauleast ,
You could build a process to push the data from all Risks lists etc. into one central list on the PWA site etc. or better still push it to something like Azure SQL DB then report of the SQL Database. There are many example 3rd party tools out there from Project partners that do this. We typically push all of the PWA data into an Azure SQL database (project, tasks, assignment, project site list data etc.) into an Azure SQL database and report from that.
Paul
Hi Paul_Mather
Might be a little outside of my skill set! Guessing that means there isn't a way with Flow to do this:(
Appreciate your help!:)