Project Online Update Fields via REST-API

[smorph]

Hey Guys,

currently im trying to automate our Project creation process with Project Online.
Goal of this flow is to create a Project after we recevied a Forms respond and updating several fields (custom fields) with input we received via Forms.

The flow runs smoothly without any error message.
But the one field im testing with right now will not be updatet on Project Online.

Hopefully you have any idea where my mistake might be.

Thanks in advance.

[Expiscornovus]

Hi @smorph,

Have you tried the updatecustomfields method?

In the thread below I have shared an example:

https://powerusers.microsoft.com/t5/Building-Flows/Use-SharePoint-Rest-API-to-update-Project-Details...

[smorph]

Hey @Expiscornovus ,

yes I've seen that already yesterday, and run through all the post today, but I even can't update the standard fields, like the description one. The flow rund through, but looking into the field it's still empty.

Right now I just want to update one custom field, later on, there are a whole more I need to update at once.

[Expiscornovus]

Hi @smorph,

Ok, lets start with a standard field like Project description.

You have tried that with below setup?

Method

PATCH

URI

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

Headers

{
  "Accept": "application/json;odata=nometadata",
  "Content-Type": "application/json;odata=nometadata",
  "If-Match": "*",
  "X-HTTP-Method": "MERGE"
}

{
"Description": "Update project description"
}

Have you also checked the queue, do you see the checkout activities?

https://learn.microsoft.com/en-us/project/manage-queue-jobs-project-server-2013

[smorph]

Allright, checked the queue and there was no "publish and check in action" visible.

Shame on me I forgot to put that action back from static result. 😓

I copied your input and now the standard field is updatet. Check now with the custom field.

[smorph]

Allright, the custom field was now updated as well.

Am I right that if I want to update several custom fields at once, the body should look like this?

{"customFieldDictionary":[{"Key":"Custom 1",
"Value":"John Doe", "ValueType":"Edm.String"}],
[{"Key":"Custom 2",
"Value":"Number", "ValueType":"Edm.Int32"}]}

---

[Expiscornovus · Accepted solution]

Hi @smorph,

I haven't tried that. But I would suggest to try this:

{"customFieldDictionary":[{"Key":"Custom 1","Value":"John Doe", "ValueType":"Edm.String"},{"Key":"Custom 2","Value":"Number", "ValueType":"Edm.Int32"}]}

[smorph]

@Expiscornovus 

That's it. Everything works fine, so far with two custom fields, the rest should be peanuts now. 😅

Thanks for your time.

[smorph]

@Expiscornovus 

I receive another issue now with my custom fields.
I get an array back from Forms but the field i want to be filled is a lookup one.

To be honest, i have no idea or clue how to solve that. Any ideas from your side?