Unanswered

Project Online connector: get resource names for a task

(0) Share

Report

Posted on by PaulD1

2,914

I'm using the Project Online connector and the Lists tasks step. I want to pull the same data as is displayed in the Task view of Project Online (e.g. Task Name, Duration, Start, Finish, Duration, % Complete and Resource Names).

Under Dynamic content I can find all these except for Duration and Resource Names.

By pasting the JSON returned by the List tasks step into a JSON viewer (http://jsonviewer.stack.hu/) I can see that Duration is returned and I can grab it simply by referencing

item()['Duration']

Question 1: Why don't all available/applicable options (such as Duration) show in Dynamic content? Is this a bug?

Even when I look at the returned JSON, I cannot find Resource Names. This is appears to be a complex field allowing multiple entries and referencing a resources table in Project Online. Searching in the JSON for names of resources I know are assigned to the tasks yields nothing and there is no property with 'resource' in the name.

Question 2: How do I get the Rource Names assigned to a Project?

Question 3: Where/how can I get information on what data I can pull from Project Online (and other connections)? Dynamic content is not reliable and even viewing/searching the underlying JSON doesn't always help, as with the example of Resource Names. Is there a central repository documenting the various connectors that is hidden beyond my googling/binging abilities?

Thanks!

Paul

All responses (16)

Answers (0)

FastTrack 96 on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

on the top of the flow (not inside the "apply to each") you have to ad the block "Initialize variable" twice, one for "AssignmentId" and also one for "AssignedTo", then you con can select the names in the "set variable" blocks at the bottom.
Community Power Pla... on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

I managed to add this Variable: SetAssignmentId
but when i click on the Name section it doesn't let me type it in.
I must be doing something wrong when adding it.

This is what i did:
I added an action, then typed in variable, then clicked "Set Variable"
But when I do this I can't change the name, or set it to anything, it's like it has a blank drop down box.
Is it possible to give me some more slightly detailed instructions?
Thank you so much.

Kind Regards

Simeon Hemus
FastTrack 96 on at

Like (0)

Report
Re: Project Online connector: get resource names for a task

Initialize a variable at top called "AssignmentId" and also one for "AssignedTo" that is used in last step
Set variable "AssignmentId" after the compose step to the expression "
@{outputs('Compose_2')?[0]?['Id']}"
Add the condition step
Community Power Pla... on at

Like (0)

Report
Re: Project Online connector: get resource names for a task

I'm trying to follow the article referred here: https://stackoverflow.com/questions/57491778/how-to-get-resource-name-for-a-task-using-microsoft-flow-project-online-connec/63396855#63396855
When i try and setup this Flow i get all the way to the section where it says:

Now set AssignmentId to...
@{outputs('Compose_2')?[0]?['Id']}

But i can't figure out how to get past this bit.

This article is not very easy for me to follow as I'm only a beginner with using Power Automate.
What I'm trying to achieve is a way I can automate the creation of Google Calendar Events for the Resources who are assigned against a Microsoft Project Online Task. I've been doing a lot of searching, but can't seem to find many good articles, I've tried piecing some together but have now got stuck.
Is anyone able to help me with this?
Community Power Pla... on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

Please see my Stack Overflow answer here... https://stackoverflow.com/questions/57491778/how-to-get-resource-name-for-a-task-using-microsoft-flow-project-online-connec/63396855#63396855
Community Power Pla... on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

@FastTrack

Thanks to your response I have been playing around in Power Automate and I finally figured out a way to Extract the "Resource Name" from Task level. I will post the details later tonight or tomorrow morning! Thanks again for your response and leading me to the right path.
FastTrack 96 on at

Like (1)

Report

Re: Project Online connector: get resource names for a task

Hi,

got stuck there some months ago and gave up.

I know that Enterprise resources are linked to a task via a resource ID and that a resource field of a task contains an array of these IDs.
The Resource table should be available via SharePoint http request pointing to the proper XML string, something like this I guessed
https://xyz.sharepoint.com/sites/pwa/_api/ProjectServer/EnterpriseResources('0edc75d1-f670-e911-afd7-983b8f0779fb')/Assignments

Best you try the API in Internet Explorer or another XML viewer :
https://xyz.sharepoint.com/sites/pwa/_api/ProjectServer/...

To understand the table structure have a look here:
https://techcommunity.microsoft.com/t5/project/project-odata-api/m-p/218694
https://docs.microsoft.com/en-us/previous-versions/office/project-odata/jj163529(v%3doffice.15)

For me it got way too complicated, so If you find a solution I bow for you!
Community Power Pla... on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

anyone figure this out yet? Still stuck in August 2020...
Community Power Pla... on at

Like (0)

Report

Re: Project Online connector: get resource names for a task

I am also looking for to retrieve the Resource ID but no way. Looked around the google for hours but no help at all.
FastTrack 96 on at

Like (2)

Report

Re: Project Online connector: get resource names for a task

Also looking for a solution - really disappointing that there is no support on this...