GET ProjectOwnerName from Project Online

(0) Share

Report

Posted on by smorph

211

Hey everyone,

I'm trying to create a flow which is triggered by an answer subbmitted via Forms.

Within the Forms the submitter needs to answer with a specific Project Name.

That one the submitter needs to lookup in an Power BI report.

In dependencie with that specific Project Name I like to identify the Project Owner Name and use that information within an email I like to send out to submitter.

The build in connectors for Project Online aren't able to output the Project Owner Name.

Any idea out there how it could be solved?

Thanks in advance and for your time.

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Sort by

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

The PO connector is very limited indeed, you can get all data using the API however.

Use conenctor SharePoint with the "Send an HTTP request to SharePoint" action.

URI: _api/ProjectData/Projects(guid'<guid of your project>')

Headers: Accept = application/json

In the output will be ProjectOwnerId and ProjectOwnerName fields.

Was this reply helpful? Yes No
smorph 211 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for getting back and trying to look into it.
I built the flow like that:

1. Trigger manually (just for testing purpose)
2. http request on project url and search for project title, because in the original flow I will get only the title form a forms answer
3. Send an email to myself to check output

For the email content i can only choose "body" as output from http request.
And that's the email content I receive:
{"odata.error":{"code":"","message":{"lang":"de-DE","value":"Die Ressource für das Segment 'Projects' wurde nicht gefunden."}}}

Here it tells me that the ressource which I'm searching wasn't found.
I already checked the URL, the projecttitle and tried to find typos to be sure that that isn't the issue.

To be honest I'm lost now.

Was this reply helpful? Yes No
shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, so two thing, add [en-us] to force the English API instead of the German one which is apparantly your default language. If you only have the project name, you can filter that using:

_api/ProjectData/[en-us]/Projects?$filter=ProjectName eq '<your project name>'

Was this reply helpful? Yes No
smorph 211 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, that worked, I'm getting now the full body information about that project including the project owner name.
Where and how should I generate the output to only get the ProjectOwnerName of that one Project?

Using a filter gave me back all ProjectOwnerNames

&$select=ProjectOwnerName

Using the "text" field of http request doesn't have any impact. I guess I use it wrong: 'ProjectOwnerName'?

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!
You can append the select to the url like this:

_api/ProjectData/[en-us]/Projects?$filter=ProjectName eq '<your project name>'&$select=ProjectOwnerName

to reference the result in a next step you can use the expression

body('Send_an_HTTP_request_to_SharePoint')['value'][0]['ProjectOwnerName']

Was this reply helpful? Yes No
smorph 211 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok got it, took me a time to understand where I should put that statement.

Using that exactly like you wrote it down, I get the first projectmanager name of the full list, not that one I expected I will get back by filtering in http request for the project name?

When trying to change the URI to:
_api/ProjectData/Projects()?$filter=Title eq '<Project-Title>'
And using
body('Send_an_HTTP_request_to_SharePoint')['value'][0]['ProjectOwnerName']
to get the specific project manager, i can't test it anymore, because power automate likes now to have access to my location...
even if i'm trying to roll back to the request before, it as well likes to have location access...

Was this reply helpful? Yes No
smorph 211 on at

Like
a
(0)

Report
Copy link

Link copied!

Recreated flow, now it works and I'm getting the result I expected.
The other flow seems to be corrupted.

Thanks for time and help.

Was this reply helpful? Yes No