Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

clearing a person (Non Multiple) picker

(0) ShareShare
ReportReport
Posted on by 95

Does anyone know if there is a working method to clear (to blank) a single people picker field in an update Singlepoint process within flows?

 

 

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: clearing a person (Non Multiple) picker

    Hi @NorsemanRoo 

     

     

    I checked my version of flow compared with my video and I found what was your issue. So in your earlier post you mentioned the following didn't worked.

     

    {
    '__metadata':{'type':'SP.Data.ApprovalsListItem'},
    'EnHApprover':-1
    }

     

     

    In my video I specified that you need the keyword Id along with the field name. See below in bold.

     

    {
    '__metadata':{'type':'SP.Data.ApprovalsListItem'},
    'EnHApproverId':-1
    }

     

    Try the above in your body and it should work.

     

    Thanks

  • Verified answer
    NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    Finally fixed this - for those that are interested.  the previous options were on the right vein but did not work.  This does:

    NorsemanRoo_0-1647426329041.png

    Hope this helps someone in the future 🙂

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    NorsemanRoo_0-1647420475215.png

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: clearing a person (Non Multiple) picker

    Could you post a screenshot of your SharePoint List settings column EnHApprover details?

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    api/web/lists/GetByTitle('Approvals')/Items(@{outputs('Compose')})

     

    I've used both getbytitle and GetByTile

     

    {
    '__metadata':{'type':'SP.Data.ApprovalsListItem'},
    'EnHApprover':-1
    }

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    NorsemanRoo_0-1647342743268.png

     

     

     

    {
     "status": 400,
     "message": "A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.\r\nclientRequestId: 16bee3d6-1fda-48d9-b898-fd3077a1d390\r\nserviceRequestId: f9f329a0-4054-3000-e9f3-73378554e8cd",
     "source": "https://heathcoatfabricsltd.sharepoint.com/GH/_api/web/lists/getbytitle('Approvals')/Items(3)",
     "errors": [
     "-1",
     "Microsoft.SharePoint.Client.InvalidClientQueryException"
     ]
    }
    
    

     

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    Sorry - Error

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: clearing a person (Non Multiple) picker

    Could you post a screenshot of the SharePoint column details metadata?

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    No- that didn't work.

    As I am using non multiple I used the first video.

     

    After a bit of configuring I got it all correct but it failed:

    Error Message:

     

    A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.
    clientRequestId: 16bee3d6-1fda-48d9-b898-fd3077a1d390
    serviceRequestId: f9f329a0-4054-3000-e9f3-73378554e8cd

  • NorsemanRoo Profile Picture
    95 on at
    Re: clearing a person (Non Multiple) picker

    Blimey that's convoluted.  I'll give it a go in the morning and let you know how I get on

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow