Unanswered

Send HTTP request to SharePoint - POST multiple fields on new list item - JSON code

(0) Share

Report

Posted on by Community Power Pla...

Hi there!

I am trying to use this REST to create a new list item. I can get it to work with just the first field ("Title"). But I can't seem to get the code right to update the second field.

As the list name is dynamic, it is not as simple as adding another step to update the list item. json code trouble.PNG

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

hi @Anonymous please see the example below

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata this is the example I started with but my flow would never resolve the "type" when I used the SP.Data.ListName.ListItem

I had to use the SP.FieldText to get my title to post. and it won't apply to the Adherence column because it is a number value. I either have the wrong type for Adherence or my JSON is written incorrectly. I am trying to use https://quicktype.io/ to format the JSON and I'm getting an error on the flow on invalid JSON.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report
@Anonymous Maeby you can try with this json

[{ "_metadata":{ "type": "SP.FieldText" }, "Title": "Week" }, { "_metadata":{ "type": "SP.FieldText" }, "Adherence": "Adherence" }]

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It didn't like the node 😞

So I reversed the {} and the [] at the beginning and end, and I'm back to the same error:

"message": "Invalid JSON. The property name '' is not valid. The name of a property cannot be empty.\r\nclientRequestId: 95c766aa-acdb-41bf-8c4b-cc0ca0d62de4\r\nserviceRequestId: ce98399f-f0dc-9000-8099-f5c92a3488ee",
"status": 400,

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Anonymous could you share an screanshot?

Was this reply helpful? Yes No
jrtraylor 45 on at

Like (0)

Report

This is an old thread so I am assuming you got it sorted out. The answer posted by @ChristianAbata is the method I use to add a new list item and fill in multiple fields for that item, I do put the __metadata line at the top of the body entry though. I however am trying use one http request action to add multiple items at once instead of having to enter the action multiple times. In my case I am trying to add multiple links to the quick launch navigation with no luck. I tried to wrap the 2 entries in [] as mentioned above but I got an error.
[{
"__metadata": {"type":"SP.NavigationNode"},
"Title": "LINK TEST 2",
"Url": "https://linka/"
},
{
"__metadata": {"type":"SP.NavigationNode"},
"Title": "LINK TEST 3",
"Url": "https://linkb/"
}]
A node of type 'StartArray' was read from the JSON reader when trying to read the start of an entry. A 'StartObject' node was expected.
clientRequestId: cafa6478-eb00-4e24-b3f3-96902f32229d
serviceRequestId: 96a69fa0-e03b-3000-4b57-d447aac80409

Was this reply helpful? Yes No
DEVREYES 99 on at

Like (0)

Report

Hello..right now I'm not sure how to update multiple columns but what I now is that you can use below JSON to update a hyperlink column:

{
"formValues":[
{
"FieldName": "ApproveorReject",
"FieldValue": "<YourLinkHere>", <YourURLName>"
}
],
"bNewDocumentUpdate": true
}

This is what I did and it works.

This is the result:
Thanks to this blog: Update single SharePoint hyperlink column in Power Automate flow

Please let me know as well if you managed to update multiple columns, I also need that tutorial. Thank you

Was this reply helpful? Yes No