Update Project Online Project Custom Field Value Using PowerShell

This PowerShell script will connect to the Project Online PWA instance, import data from a CSV file then update the appropriate projects with the data from the CSV file. This demonstrates a simple example for importing the project budget value from a CSV file.

 
 
 
 
 
5 Star
(4)
1,144 times
Add to favorites
Project Server
11/7/2016
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • how to update field have Boolean value
    1 Posts | Last post June 13, 2019
    • we are trying to update custom field with Boolean value
  • Setting a custom field with Lookup
    4 Posts | Last post May 08, 2019
    • Hello, Thanks for the great solution.
      It works fine on Project server 2016 on premise.
      Although i have tried to modify the solution to set the field based on a lookup value,
      but it has failed so far.
      Could you help with a possible fix for this ?
    • Hello, thanks for the feedback. As you have found, this code will not work to update a field based on a lookup table as they are set differently. It wouldn't be a fix, it would be a new script and something I may add in the future.
      Paul
    • Thanks for your feedback.
      Apparently, passing the LookupMemnberUID as an Array will update the lookup field.
      all i need to do here is to make my csv to have guid instead of the actual memberValue.
      Its a lot to do, but its better than non
      
      $draftProject.SetCustomFieldValue($customFieldInternalName, [Array]$_.LookUpMemberUID
    • Hi , 
      I tried to use this script on our project server 2016 on premise. I got the following error 
      
       The error details are: Method invocation failed because [Microsoft.ProjectServer.Client.DraftProject] does not contain a method named 'SetCustomFieldValue'.
  • Lookup table and field inventory report for project server 2010 request
    1 Posts | Last post February 03, 2019
    • Hi,
      
      Could you please help me or guide me how to identify export inventory report for lookup table and field utilization report in project server 2010, please.
      
      We are planing for project server migration and i am looking for each end every lookup table and field utilization report.
      
      thank you in advance for your help. 
      
  • Could you please help me while exporting all custom lookup table and values as a inventory report for project server 2010
    1 Posts | Last post February 03, 2019
    • Could you please help me while exporting all custom lookup table and values as a inventory report for project server 2010 
  • Where are the DLLs referenced in the script?
    4 Posts | Last post June 30, 2017
    • Hello, I've tried using the script and am unable to download the DLLs through Visual Studio. I am by no means an expert but not being able to locate these DLL files makes it impossible for me to use this. Any suggestions?
    • I get the dll's from the package here once the package is added to Visual Studio: https://www.nuget.org/packages/Microsoft.SharePointOnline.CSOM
    • I found the DLLs and I got it to work with text fields - Thanks! Has this ever been tested for a choice field or one with a lookup value?
    • This script won't work for lookup fields - it will require some minor re-work to support lookup fields.