Unanswered

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

Like (0) Share

Report

Posted on 24 Jul 2023 19:48:20 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?

I have the same question (0)

All responses (6)

Answers (0)

ximz 21 on 11 Jun 2024 at 08:17:54

Like (0)

Report

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

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
Expiscornovus 32,205 Most Valuable Professional on 31 Jul 2023 at 09:32:49

Like (0)

Report

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

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
0__0 6 on 27 Jul 2023 at 17:09:11

Like (0)

Report

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

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

Was this reply helpful? Yes No
0__0 6 on 27 Jul 2023 at 16:42:08

Like (0)

Report

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

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 25 Jul 2023 at 15:35:03

Like (0)

Report

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

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

Thank you for the information!

Was this reply helpful? Yes No
Expiscornovus 32,205 Most Valuable Professional on 25 Jul 2023 at 12:24:43

Like (0)

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

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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates