Automate your projects with Microsoft Flow and Project Online

Today I had a look at Project Online and although there have been some changes  to Project Online since I last used it, the fundamental product is still similar. I’m especially interested in the Project Online Connector in Microsoft Flow. The connector is a bit limited, however there are some basic operators available that would have helped me in past projects. I guess all this connector needs is more users requesting new actions and triggers.

In this post I’m going to have a look at the actions and triggers that are already there.

List Projects

My starting point is to list all the existing projects  using the List projects action

Automate your projects with Microsoft Flow and Project Online Microsoft Flow, Microsoft Office 365, Microsoft Project listprojects

The tooltip is slightly confusing as your project online Root Site URL will most likely be /sites/pwa and I can’t really imagine Project Online existing within /teams/sampleteam.

Create Tasks

Then I tried to have a look at creating a task in every single project by taking the proejct Ids returned by the List Projects

Automate your projects with Microsoft Flow and Project Online Microsoft Flow, Microsoft Office 365, Microsoft Project createtaskforallprojectsQuite easily I can create a new task with the creates new task action, the options however are quite limited.  Also, the creation of the task will fail if a project has been checked out by someone else or if the project hasn’t been checked out. Therefore you will need to handle check in and check out by adding some more actions.

In a similar way it is also possible to create resources or projects. These actions potentially make it possible for Flow to create projects, tasks or resources when users add projects requests to a project request list in SharePoint or any other data source that supports Flow triggers. Imagine creating a team in Microsoft Teams triggering the creation of a Project plan in Project Online without the need to have administration rights in Project Online.

Triggers

There are a number of triggers available within the Project Online connector. These triggers make it possible to trigger a flow when a new project has been created,  when a new resource is created , when a new task is created or when a project is published.

These triggers could help for example when you want to inform people when something changes to a project. This way you could for example let a project manager know when a project plan has been updated.

Automate your projects with Microsoft Flow and Project Online Microsoft Flow, Microsoft Office 365, Microsoft Project whenaprojecthasbeencreated

Conclusions

So even though the Project Online connector could do with some additional features. I do think that the current connector could be helpful in many scenarios. If you are interested in making this connector work for you then please do leave a comment below, as I’;m interested to know if this connector is used by many organisations or not.

 

 

8 thoughts on “Automate your projects with Microsoft Flow and Project Online

  1. actually i use for my company Project Online and i wanted to migrate my workflows to Flow, but this connector is kind of useless if you have custom fields and want to do any kind of approval workflow, it wil be great if this connectors were updated.

  2. Hello,
    There is no option to select Project Type(EPT) while creating a project using Flow. Please suggest how we can do this. Thanks.

  3. To quote Churchill this is like a lighthouse in the Alps, brilliant but useless. I cannot believe that there are not connectors to replicate the Workflow that is needed to allow Project Workflow to be deployed – at present it looks like the workflow phases and stages aspect of Project Online is frustrated. I have read about the flows that can currently be created using Project Online data and my reaction is “so what” – they seem to offer virtually nothing of merit or value compared to what used to be possible with Project workflow.

    At present it looks like Microsoft are selling a partial solution when it comes to the Project Workflow aspect of PWA.

  4. Came here looking for Project worflow solution using Power Automate, but from the comments I see this is not available yet. Would be a great enhancement since project flows using Sharepoint Design are really limited and visually outdated.
    Will take a look in the REST api but I was not willing to expend that much time developing a solution.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,909 other subscribers

Recent Posts

Archive

Thank you for visiting SharePains