Unanswered

Attempting to GET data from Project web app. Wanting to use "Send an HTTP request to Sharepoint"

(0) Share

Report

Posted on by 0__0

Currently researching ways to migrate SharePoint workflows to Power Automate. One workflow is to get/submit/update project stages. I am looking to GET work flow stage using the Power Automates SharePoint connector "Send an HTTP request to SharePoint. I am not quite sure where to pull from as the information is not held in a list that I can see. Could someone point me in the correct direction?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Expiscornovus 33,801 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @0__0,

If you are looking for the management of stages itself you can probably use the methods listed below:

https://learn.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj669261(v=office.15)

As far as I am aware you should also be able to find the project stage on the project detail pages. So, I expect you should also be able to interact with those stage values on a per project basis via the REST API:

_api/ProjectServer/Projects('ProjectGUID')/Draft

In this thread I shared a couple of examples:

https://powerusers.microsoft.com/t5/Building-Flows/Use-SharePoint-Rest-API-to-update-Project-Details-in-PWA/m-p/870543

Was this reply helpful? Yes No
0__0 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @Expiscornovus,
I will give that a try and report back.

Thank you for the information!

Was this reply helpful? Yes No
0__0 6 on at

Like (0)

Report
Copy link

Link copied!

I tried a few different combinations of this:
sharepoint.com/sites/pwa/_api/ProjectServer/Stages/getByGuid('uid')
Was expecting to get the stage value instead of just $true. I am misunderstanding the method documentation?

I also attempted your example above:
_api/ProjectServer/Projects('ProjectGUID')/Draft
But I get a 400 error.

If I remove Draft I get full output but I see return data only under Tasks

Was this reply helpful? Yes No
0__0 6 on at

Like (0)

Report
Copy link

Link copied!

Here is body if I switch to verbose
{"d":{"GetByGuid":null}}

Was this reply helpful? Yes No
Expiscornovus 33,801 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @0__0,

I believe that first endpoint is just the definition of the stages. So, in your case I would suggest to focus on the draft method of a project.

What did you test? Did you try to update a stage with a PATCH? If so, have you checked out the project first in your flow setup (with a checkout project action) before you tried to change the draft version of it via a HTTP request?

Was this reply helpful? Yes No
ximz 21 on at

Like (0)

Report
Copy link

Link copied!

Hi @0__0,

I am using the below query to get the current PhaseName for a Project:

I gues you only need to add StageName to the $select.

Did you found a way to submit a Project workflow through Power Automate using REST API?

Thanks!

Was this reply helpful? Yes No