Answered

Copying Sharepoint list item - Invalid Request when copying multiple choice column

(0) Share

Report

Posted on by CU04122253-0

Good afternoon,

I'm currently trying to copy a Sharepoint list item from one list to another. The item is copied to a new Sharepoint list that is created automatically by the flow. However, I'm encountering a "400 - Invalid Request" error whenever I try to copy the data in a multiple choice colum. If I remove the request to copy that column, the HTTP request runs normally. Below is my current flow and the column definition for the problematic column. Any help is appreciated.

Here is the call to the HTTP request.

Here is an example of a request I am sending, with the body of the http request

And here is how the column is defined within the list (as shown by the request GET /sites/{site-id}/lists/{list-id}/columns)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Suggested answer

Artur Stepniak 1,539 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello,

have you checked what's the output of Select action? Probably it's incorrectly formatted (not in an expected JSON format). Not sure why you're using HTTP request instead of Create item action - is it some kind of a custom solution?

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Was this reply helpful? Yes No
Verified answer

CU04122253-0 32 on at

Like (1)

Report
Copy link

Link copied!

Thank you for your reply Artur,

I was using the HTTP request since the site address and list name are based on dynamic content, and the Create Item action wasn't showing the fields to fill when using dynamic. I'm pretty new to Power Automate so I didn't really know how to fix that, and the Create Item documentation was pretty vague on the format for the "Item" field. After some trial and error with the Create Item action, I was able to make it work for the column "Category0", but then the columns "Progress" and "Priority" stopped working. I used the same format for the Create Item but removed the "fields":{} line. The solution I came up with was sending the HTTP request without the "Category0" field, and then use the Update Item action to fill in the information for Category0, though if you have any ideas on how to make it all work on the Create Item action it would be of great help.

Thank you.

Was this reply helpful? Yes No
Verified answer

CU04122253-0 32 on at

Like (0)

Report
Copy link

Link copied!

Never mind, I was able to figure out the correct format for the Create Item action. Turns out the "Progress" and "Priority" fields also need to be passed as { "Value": "XXXX"} to work.

Thanks.

Was this reply helpful? Yes No