Delete a cell in sharepoint once the status is changed

[JayanthanJ]

Hi,

 I am new to Power automate and need help with this. I have created a sharepoint tracker list in which the following fields are present (as per the below screenshot). 

I want to delete(or make it blank) the next steps and next steps owner fields once the status is closed. Using power automate, I am able to delete the next steps using update item. In order to delete the next steps owner field, I used Send an HTTP request to Sharepoint function (added the screenshot) .

But it wasn't working. An error(added the screenshot again) throws up which says "Item does not exist. It may have been deleted by another user.
clientRequestId: e879a808-c858-4229-9ef5-429701e8cf4b
serviceRequestId: 497208a0-b059-1000-68c4-80862fd53003"

Can someone please help me to solve this issue?

[v-jefferni]

Hi @JayanthanJ ,

Would you like to set a choices column to be null within a SharePoint list?

If so, please refer to below thread:

https://powerusers.microsoft.com/t5/Process-Advisor/Empty-field-Choice-column/td-p/825282

1. Use Compose to generate a blank value

2. Use this blank value in Update item action

Result in my test:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[JayanthanJ]

Hi @v-jefferni,

                Actually the column which I want to nullify has the data type Person or Group i.e mail ids extracted from the directories.

Thanks 

Jayanthan Jayasenan

[v-jefferni · Accepted solution]

Hi @JayanthanJ ,

Then you have a small mistake in the body of Send HTTP request action, below is the whole approach:

https://www.shanebart.com/power-automate-reset-sp-person-field/

URI: _api/web/lists/GetByTitle(‘TestList’)/items(<ID>)

Headers:
Accept: application/json;odata=verbose
IF-MATCH: *
X-HTTP-Method: PATCH
Content-Type: application/json;odata=verbose

Body:
{
“__metadata”: {‘type”:”<ListItemEntityTypeFullName from Step 1>“},
“fieldnameStringId”:”,
“fieldnameId”:-1
}

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.