Unanswered

Update SharePoint field using REST api (BadGateway)

(0) Share

Report

Posted on by JimmyW

2,563

I have been updating some SharePoint columns/fields using REST api, and everything works, except if the list has minor and major version activated. Then i will get the error

"message": "Additions to this Web site have been blocked.\n\nPlease contact the administrator to resolve this problem.

If i check out and check in the file when the flow is running then it will work, but if i use check out and check in function in the flow then it fails again with the same error message.

2019-11-08 09_00_25-Edit your flow _ Power Automate.png

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-litu-msft on at

Like (0)

Report

Hi @JimmyWork,

Please try to update the item using the following method:

Headers:

accept: application/json;odata=verbose

content-type: application/json;odata=verbose

X-HTTP-Method: MERGE

IF-MATCH: *

body:

{

'__metadata': { 'type': 'SP.List' },

'columnName': 'New value',

}

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@v-litu-msft
Thank you, the issue is that i do not want to create a new version when i update the column. That is why i use the way i do. I will try what you posted but it will result in a new version being created of the item.

I should add that my column is a "choice" column and not a single line column

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@v-litu-msft As im using a choice column that i want to update your solution wont work. I also wish to update the column without adding a new version if possible. It seems this worked before but currently not anymore, not sure why?

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report
Hi @JimmyWork,

If it is a choice type, you can refer to the following:

{'__metadata': { 'type':'SP.ListItem' }, 'TestColumn': { '__metadata': { 'type' : 'Collection(Edm.String)', results: ['Test1']}}}

When versioning is enabled, versions are created in the following situations:

When a list item or file is first created or when a file is uploaded.

Note: If file checkout is required, you must check the file in to create its first version.

When a file is uploaded that has the same name as an existing file.

When the properties of a list item or file are changed.

When an Office document is opened and saved. After a document is opened again, a new version will be created after an edit is saved.

Periodically, when editing and saving Office documents. Not all edits and saves create new versions. When saving edits frequently, for example, each new version captures a point in time rather than each individual edit. This is common when autosave is enabled.

During co-authoring of a document, when a different user begins working on the document or when a user clicks save to upload changes to the library.

There can be up to three current versions of a file at any given time: the checked-out version, the latest minor or draft version, and the latest published or major version. All other versions are considered historical versions. Some current versions are only visible to users who have permissions to view them.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@v-litu-msft Thank you for helping me out.
When i try your part now i get:

A collection was found without the 'results' property. In OData, each collection must be represented as a JSON object with a property 'results'

The "bNewDocumentUpdate": true would update the item without adding a version to it even if you change a column status.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @JimmyWork,

After you update it via API, you can use the Get item action to get the whole collection.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No