Sign in
 
Home20132010Other VersionsLibraryForumsGallery

Keep Project Online data in sync with SharePoint list

This PowerShell script will use the Project Reporting OData API to get all of the published projects in the Project Online PWA Site Collection, then for each project it will create / update a list item on the specified SharePoint list.

 
 
 
 
 
5 Star
(1)
822 times
Add to favorites
Project Server
3/1/2018
E-mail Twitter del.icio.us Digg Facebook
  • Hide
    Running script on schedule
    1 Posts | Last post February 12, 2020
    • Written February 12, 2020 
      Hi Paul,

I have this setup a working as described and would like to get the script to run on a schedule through O365.  Original thoughts were to upload the script to the site assets library on PWA and create a scheduled flow to kick it off once a day.  I was not able to find a solution for this without creating an Azure Automation environment.  Do you have any ways of running this automatically from O365 using PowerAutomate, PowerApps or any other tool?
  • Hide
    Updating
    1 Posts | Last post July 07, 2018
    • Written July 07, 2018 
      By update-run script it doesn't update but just create a new-item ("old-item" is also still on the list)? Is any special setting needed in list/ site?. I've downloaded the script and adjusted only item names and ofcourse the url/login/etc-info.