Forum Discussion

Copper Contributor

Dec 05, 2019

Historic RAG

Hi Does anyone know a simple way to collect historic RAG statuses etc. from Project Online? We want to show month on month changes to statuses however all reporting is 'live' - help!:) Thanks ...

MVP

Dec 11, 2019

Here is a simple solution: https://pwmather.wordpress.com/2018/12/14/projectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform/

Paul

pauleast
Copper Contributor
Dec 18, 2019
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!
- Paul_Mather
  MVP
  Dec 18, 2019
  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
  - pauleast
    Copper Contributor
    Dec 19, 2019
    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

Share

Resources