Skip to main content

Notifications

Power Automate - General Discussion
Answered

how to clear a person?

(0) ShareShare
ReportReport
Posted on by 62

suthichaia_0-1635089329417.pngsuthichaia_1-1635089373296.png

I tried it but it didn't work.

  • smorley Profile Picture
    smorley 544 on at
    Re: how to clear a person?

    Solved @ekarim2020 - there was a different internal list name.  I did find out  that you need _x0020_ if your name has spaces.

  • Ellis Karim Profile Picture
    Ellis Karim 10,547 on at
    Re: how to clear a person?

    Hi @smorley 

     

    Confirm you have the correct ListItemEntityTypeFullName for the list "Loan Manager". 

     

    Please see section 5. How to CLEAR a People column using Power Automate of the post 🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps and confirm you have the correct ListItemEntityTypeFullName for the list "Loan Manager".

     

    This post shows how to CLEAR a People column using Power Automate:

    • Get the ListItemEntityTypeFullName
    • Clear a SINGLE select People column
    • Clear a MULTI-SELCT People column

    Hope this helps.


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site

  • smorley Profile Picture
    smorley 544 on at
    Re: how to clear a person?

    @ekarim2020 I'm going to add to the pile.  I'm getting the error of:
    A type named 'SP.Data.Loan_x0020_ManagerListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.

    The name of my list is "Loan Manager" so I added the '_x0020_"

    smorley_1-1681136110005.png

     

    Based on your post, here is the body of the http action:

    {'__metadata':{'type':'SP.Data.Loan_x0020_ManagerListItem'},
    'CurrentOwnerStringId':'',
    'CurrentOwnerId':-1
    }

     

    The internal name of my people/group field is "CurrentOwner" without any spaces.

     

    Any help that you could give would be greatly appreciated.

  • suthichaia Profile Picture
    suthichaia 62 on at
    Re: how to clear a person?
    I can do it. I really appreciate all the hard work you’ve done to help me.

     

    suthichaia_0-1635171631201.png

     

  • Ellis Karim Profile Picture
    Ellis Karim 10,547 on at
    Re: how to clear a person?

    To do the clear operation, you must know the correct ListItemEntityTypeFullName property of the list and pass that as the value of type in the Send an HTTP request to SharePoint body.

     

    It seems that the ListItemEntityTypeFullName property value SP.Data.BTToolsDataListItem specified in the flow may not be correct.

     

     Use the following rest call to get the ListItemEntityTypeFullName

    ekarim2020_0-1635153258561.png

     

     

     

    Uri:
    _api/web/lists/GetByTitle('People')?$select=ListItemEntityTypeFullName
    
    Headers:
    {
     "Accept": "application/json;odata=nometadata"
    }

     

     

     

    Then examine the runtime output of the request to get the text for the ListItemEntityTypeFullName

    2021-10-24_20-47-22.png

     


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

  • suthichaia Profile Picture
    suthichaia 62 on at
    Re: how to clear a person?

    Flow run failed
    suthichaia_0-1635119056069.pngsuthichaia_1-1635119160499.png

     

  • suthichaia Profile Picture
    suthichaia 62 on at
    Re: how to clear a person?

    Flow run failed
    suthichaia_0-1635119056069.pngsuthichaia_1-1635119160499.png

     

  • Verified answer
    Ellis Karim Profile Picture
    Ellis Karim 10,547 on at
    Re: how to clear a person?

    Although there may be other ways to do this, it can be done using a HTTP request to SharePoint:

    ekarim2020_0-1635104864703.png

     

    Uri:
    _api/web/lists/GetByTitle('People')/items(69)
    
    Headers:
    {
     "IF-MATCH": "*",
     "X-HTTP-Method": "MERGE",
     "Content-Type": "application/json;odata=verbose",
     "Accept": "application/json;odata=verbose"
    }
    
    Body:
    {'__metadata':{'type':'SP.Data.PeopleListItem'}, 
    'PMStringId':'',
    'PMId':-1
    }

     

    Here is an example of clearing the PM field from a SharePoint List called People. The list item ID is 69:

    2021-10-24_20-31-09.png

    Use the internal name for the Person field, not the display name.

    2021-10-24_20-54-03.png

     

    For more info please see:


    Ellis

     


    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard