cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JayanthanJ
Frequent Visitor

Delete a cell in sharepoint once the status is changed

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). 

JayanthanJ_0-1638348941338.png

 

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) .

JayanthanJ_4-1638349245969.png

 

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"

 

JayanthanJ_3-1638349117801.png

 

Can someone please help me to solve this issue?

 

1 ACCEPTED SOLUTION

Accepted Solutions

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
}

vjefferni_4-1638522007533.png

 

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
v-jefferni
Community Support
Community Support

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

vjefferni_0-1638520974620.png

 

2. Use this blank value in Update item action

vjefferni_1-1638521030469.png

Result in my test:

vjefferni_2-1638521044446.png

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.

 

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

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

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
}

vjefferni_4-1638522007533.png

 

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,409)