Updating fields for multiple project using MS Project and Project Online

[Norman Christensen]

Hello,
I am an administrator for Project Online (PWA) and I need to update a field in all of the projects that are on the server.
I thought I saw where you could bring the projects in question into MS Project, update the field and save back to PWA. This also requires that the project be published before the change takes place.

I wrote a FLOW that checks out all projects, publishes and checks then back in. Works great. However, I can’t seem to get the updates to the field to work. I can’t purchase an add-on to PWA for this purpose, so I am trying to accommodate this using this method (that is not working).

Has anyone done this successfully?

Thanks.

[Sai Prasad]

Yes, Project Online connector (https://docs.microsoft.com/en-us/connectors/projectonline/) doesn’t support updating fields yet. You can use update enterprise fields as well as custom fields with workflow but one project at a time – https://docs.microsoft.com/en-us/office/client-developer/project/bulk-update-custom-fields-and-create-project-sites-from-workflow-in-project. So, you will still retain the Flow that checks out all projects, publishes and checks-in back. You write a workflow that gets triggered when check-in / publish event happens, and updates the enterprise fields or custom fields.

[Author]

Posts