Answered

Sharepoint List Field modification PUT/POST/PATCH request times out

(0) Share

Report

Posted on by LZ-06081459-0

Hi, I want to add a choice option to a sharepoint list multichoice field. I want to do so using Power Automate, making an HTTP request to Sharepoint. As I want to modify an existing field, I use a PUT request, but the same issue persists with POST.

My request is structured as follows

Uri: _api/web/lists/getbytitle(<List>)/fields/getbyinternalnameortitle('Testspalte')

(This works correctly, GET is successful and delivers all metadata)

Headers: Content-Type, accept = application/json;odata=verbose
If-Match = *

Body:

{
"__metadata": { "type": "SP.FieldMultiChoice" },
"Choices": {
"__metadata": {
"type": "Collection(Edm.String)"
},
"results": [
"Choice 1",
"Choice 2",
"Choice 3",
"Choice 4" (so the new choice)
]
}
}

When running this request, it runs for 11 minutes and then times out. If I run a simple GET request for the field, I get all relevant metadata. I have already run the flow with a system admin account, which gives the same issue. I've tried the same logic on a "normal", non-multichoice field, but still the same issue.

What can I do?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @LZ-06081459-0,

Can you try and use the getbytitle method instead to retrieve your field? Also try and use a PATCH method instead.

Try the below

ChoicesArray

[ "Choice 1","Choice 2","Choice 3","Choice 4" ]

Method

PATCH

URI

_api/web/lists/getbytitle('<List>')/fields/getbytitle('Testspalte')

Headers

{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose", "If-Match": "*" }

Body

{ "__metadata": { "type": "SP.FieldChoice" }, "Choices": { "results": @{variables('ChoicesArray')} } }

Test result added choice

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
LZ-06081459-0 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus, thanks for the quick reply. I tried implementing the exact solution as proposed by you; still, I get a non-specified timeout. The field is correctly specified as my GET call returns all necessary information, both with my and your syntax.

I do get a "Retry history" where it says one retry and then bad gateway. I guess this is relevant; however, I don't understand it. The GET request apparently has the correct gateway, the OAuth is working and the issue persists if the admin runs the flow.

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

Like (0)

Report
Copy link

Link copied!

Hi @LZ-06081459-0,

Can you share a screenshot of your current setup, maybe I am able to spot why it is not working based on that.

Are you using the outputs of the GET request in your PATCH request?

Was this reply helpful? Yes No
LZ-06081459-0 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus, attached my flow. Testspalte2 is multi-choice, Testspalte is single-choice, but it does not work for either of them, regardless of SP.FieldMultiChoice or SP.FieldChoice.

I do not run the GET request in the same flow as it's only for testing purposes. Also, no info from the GET is necessary.
In theory I could run a GET, store it as text, replace the relevant section and run a PATCH that replaces the whole metadata, maybe. But to my understanding this isn't the issue here. Rather confused about the bad gateway.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @LZ-06081459-0,

It looks like your URL in the URI field has two lines, caused by a trailing space character. Make sure there is no space directly after the last ')' and it is just a single line. Can you remove that and try again? Same for the accept header value.

Was this reply helpful? Yes No
LZ-06081459-0 10 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus you have a sharp eye. Can't believe it, it worked now. Some hours of my life wasted, but at least it works. Thank you!!

Was this reply helpful? Yes No