Unanswered

Project Online Update Fields via REST-API

(0) Share

Report

Posted on by smorph

211

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.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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-in-PWA/m-p/870837/highlight/true#M122291

Was this reply helpful? Yes No
smorph 211 on at

Like (0)

Report

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.

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

Like (0)

Report
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

Was this reply helpful? Yes No
smorph 211 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
smorph 211 on at

Like (0)

Report
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"}]}

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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"}]}

Was this reply helpful? Yes No
smorph 211 on at

Like (0)

Report

@Expiscornovus

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

Thanks for your time.

Was this reply helpful? Yes No
smorph 211 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No