Answered

Sharepoint Post Request - ValidateUpdateListItem

(0) Share

Report

Posted on by Community Power Pla...

Hi All!

Recently I have started playing with Flows and have had some success, unfortunaltey, I now seem to be in an issue that is well documented - Updates to a list re-triggering a flow in a Sharepoint List. I have the below node in my flow that returns this error:

{"status": 400,

"message": "Value cannot be null.\r\nParameter name: formValues\r\nclientRequestId: 1a290845-d9f4-4bc1-83db-ab6f29fd61ee\r\nserviceRequestId: b2a1f59e-4012-9000-f494-e36f7a7dca23",

"source": "mysiteurl (replaced from actual url) /_api/web/lists/GetByTitle('Cash%20&%20Mitigation%20Benefits%20Tracker')/items(9)/ValidateUpdateListItem",

"errors": [

"-2147467261",

"System.ArgumentNullException" ]}

My Sharepoint list column I am referencing is a mandatory field, and is a Choice type field. The "Pending" option is a selectable option

MS Flow Node set up

I have been referencing this post for this task:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/Flow-Existing-item-is-modified-triggers-when-a-new-item-is/td-p/88141/page/2

Any help would be greatly appreciated!

All responses (5)

Answers (1)

Gopi 17 on at

Like (0)

Report

Re: Sharepoint Post Request - ValidateUpdateListItem

Hi, my flow run successfully with below body but value is not updating in share point library. Do you have any solution for this?

{
"formValues":[
{
"FieldName": "DocumentType",
"FieldValue": "SecureDocuments"
}
]
}
RezaDorrani 12,141 on at

Like (1)

Report

Re: Sharepoint Post Request - ValidateUpdateListItem

Hi @Anonymous

Set bNewDocumentUpdate to false and try

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
v-yamao-msft on at

Like (0)

Report

Re: Sharepoint Post Request - ValidateUpdateListItem

Hi @Anonymous ,

Do you want to update a Choice field using action Send an HTTP request to SharePoint?

The following configuration is working fine for me, please check it for a reference.

Best regards,

Mabel
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Post Request - ValidateUpdateListItem

Hi @RezaDorrani

Thanks for this, removing the X-HTTP header let it work!
Now have a new problem, if you happen to have any gems on this! I did the POST request to try to avoid re triggering the Flow when I do an update within it, unfortunately this method still triggers the flow and loops, any thoughts?

Thanks for your help!
Verified answer

RezaDorrani 12,141 on at

Like (7)

Report

Re: Sharepoint Post Request - ValidateUpdateListItem

Hi @Anonymous

try with headers

accept application/json; odata=verbose (all lower case - not sure if this matters though)
content-type application/json; odata=verbose (all lower case - not sure if this matters though)

if-match and x-http-method not required

I tried with a mandatory choice column and it worked

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly