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

Power Automate - flow for updating single value person column using "Send an HTTP request to SharePoint" action - Updating single value person column to null
Power Automate - flow for updating single value person column using "Send an HTTP request to SharePoint" action - Updating single value person column to null

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
fig : SharePoint list
fig : SharePoint list
  • 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
fig : Power Automat - Instant flow - with manually trigger
fig : Power Automat – Instant flow – with manually trigger
  • 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
fig : Power Automate - "Send an HTTP request to SharePoint" action - Updating reviewer  column to null
fig : Power Automate – “Send an HTTP request to SharePoint” action – Updating reviewer column to null

Complete flow:

fig : Power Automate - flow for updating single value person column using  "Send an HTTP request to SharePoint" action - Updating single value person column to null
fig : Power Automate – flow for updating single value person column using “Send an HTTP request to SharePoint” action – Updating single value person column to null

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

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

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: