I'm just posting this here as I don't like to upload the data to the solutions part of things
This should work if you're having trouble creating or updating a SharePoint list item column item to a null value.
This has been seen over a variety of column types.
Answer follows in a second.
Please go and vote up the feature update that's been 'PLANNED' for nearly 5 years:
Allow us to update a numeric field to null/blank value
Solved! Go to Solution.
This should get what you need, feel free to replace GetById with GetByName and use the list name (I just know that I change mine a lot ).
Send an HTTP request to SharePoint
Create a Send an HTTP request to SharePoint action as a POST in your flow:
The only caveat is that you may need to ensure that you have the right type if you're doing cleverer things with your SharePoint list.
URI
_api/web/lists/GetById('YOUR_LIST_ID')/items(ITEM_ID)
Header JSON
{
"Content-Type": "application/json;odata=verbose",
"Accept": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
}
Body JSON
{
"__metadata": {
"type": "SP.Data.LIST_NAMEListItem"
},
"YOUR_LIST_COLUMN_NAME": null
}
This should get what you need, feel free to replace GetById with GetByName and use the list name (I just know that I change mine a lot ).
Send an HTTP request to SharePoint
Create a Send an HTTP request to SharePoint action as a POST in your flow:
The only caveat is that you may need to ensure that you have the right type if you're doing cleverer things with your SharePoint list.
URI
_api/web/lists/GetById('YOUR_LIST_ID')/items(ITEM_ID)
Header JSON
{
"Content-Type": "application/json;odata=verbose",
"Accept": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
}
Body JSON
{
"__metadata": {
"type": "SP.Data.LIST_NAMEListItem"
},
"YOUR_LIST_COLUMN_NAME": null
}
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
23 |
User | Count |
---|---|
61 | |
46 | |
43 | |
30 | |
27 |