Small Tips and Tricks : Power Automate – Removing value of column of type “single value person” using “Send an HTTP request to SharePoint” action

Hi All,

Greetings for the day !!!

New short tip again related to Power Automate.

Tip : Removing value of column of type “single value person” using “Send an HTTP request to SharePoint” action

Background :

• One of my team member was trying to update list field of type “single value person”, we need to remove the value means making it empty. Tried bit but getting an error.

So small poc / demo

Details :

• Create simple list “UpdatePerson” list with following columns
  • Title – Single line of text
  • Reviewer – Person or Group

• Created instant flow “Demo-UpdateUserColumn” with trigger “manually trigger a flow“
• Added action “Send an HTTP request to SharePoint” to have POST request to update person column

• Following are the values for “Send an HTTP request to SharePoint” action
  • Site Address – site where our list of which we need to update the items
  • Method – POST
  • Uri – /_api/web/lists/getbytitle(‘UpdatePerson’)/items(1)
  • Headers –
    • content-type – application/json;
    • accept – application/json;
    • IF-MATCH – *
    • X-HTTP-Method – MERGE
  • Body – { “ReviewerId”: -1} – Here -1 is used to nullify the value in Reviewer column

Complete flow:

Thanks for reading!! Feel free to discuss in case any issue / suggestions / questions

HAVE A FANTASTIC TIME AHEAD !!! LIFE IS BEAUTIFUL 🙂