web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Clear people picker bo...
Power Apps
Answered

Clear people picker box in SharePoint list

(0) ShareShare
ReportReport
Posted on by 7

I have built a simple inventory tracking app using a SharePoint list.  I have a field in the list called "Checked Out To" that is a people picker to select a user.  In the app, I have a screen for "Check In" and I want to clear the "Checked Out To" field.  For the combo box on the form, I tried deleting the values in "Default" and "DefaultSelectedItems" properties, and it looks like it works (combo box says "Find Items").  But when I submit the form in the app, the value in the list doesn't change (still shows being checked out to the same person).  Thanks in advance for your help.

 

ComboBoxProperties.png
Categories:
  • OneThing Profile Picture
    393 on at

    Hi @RPRockman,

     

    When you are clearing the Default value you are telling powerapps not to use the value so it displays as empty. When you are submitting the form you have nothing in your field to write back so sharepoint keeps the original data.

     

    I think you would need to set the default to something like Blank() which will set the field to null.

     

    I can't test this on sharepoint at the moment, but here is a link with more information https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty

     

    Thanks,

    Nicky

  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    HI @RPRockman,

    Do you want to clear Person column value within Edit form of your app?

    The user @AnonyMouse has faced similar issue with you, please check the following thread:

    https://powerusers.microsoft.com/t5/General-Discussion/Clear-DateField-and-Lookup-Column-value/m-p/136709

    I also agree with @OneThing's thought almost. If you don't provide a value for the People picker box (a Combo Box control) when you edit a record within the Edit form, PowerApps Edit form would think that you don't make any changes to the People Picker column (Person column), so the old value within the Person column would not be changed.

    Currently, I afraid that there is no way to clear the People picker box value (Person column, decorated as a Combo Box control) within the Edit form in PowerApps.

    Note: I  don't the Blank() function could achieve your needs.

    If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

    https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

     

    Best regards,

    Kris

  • RPRockman Profile Picture
    7 on at

    Thanks, Nicky and Kris for your response.  Kris, you were correct, the Blank() idea didn't work.  I will submit something to the idea board so it can be fixed.  Bummer!  Cheers.

  • Verified answer
    manojmittal Profile Picture
    43 on at

    Getting same and found the workaround. Hope it will help

     

    Do the below settings and It allow to save people picker as blank values.

    PowerApp_SetNullValue.pngReference:- https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-databases/

     

  • joshnystrom Profile Picture
    262 on at

    Hi all, I found a way to do this that doesn't rely on the experimental features, nor a Flow, so I thought I'd surface it here.

    My current understanding of my approach makes a few assumptions (I'm not certain whether they are integral to its use):

    -You are treating this like a "Complex" data update and are therefore using Patch statements to merge into the existing SP List item
    -Your app has a way to detect when the person-picking control was left blank so that you can conditionally change which Patch statement is being executed

    -You are using the out-of-the-box people picker or can otherwise tweak my approach to match a "valueless" Person record

    All I've done is prep a "BlankPeople" variable that is manually shaped as a single, blanked-out Person record for the SP Person/Group field, as follows:

    Set(BlankPeople,Table({'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims:Blank(),DisplayName:Blank(),Email:Blank(),Department:Blank(),Picture:Blank(),JobTitle:Blank()}))

    When Patching with this as my payload when the People picker control is left blank, I've been able to Clear the corresponding field on my SP List item.

     

    Hope this helps someone!

    Josh


     

    E: In this thread - https://powerusers.microsoft.com/t5/General-Discussion/Clearing-out-people-picker-field/m-p/249368/highlight/true#M73215 - RandyHayes indicated that this approach is working for LookUp fields as well.
    E2: In this thread - https://powerusers.microsoft.com/t5/Building-Power-Apps/Clearing-out-people-picker-field/m-p/258564#... - my testing clarified that Date and single-Person fields were still reliant on the experimental feature, at least at the time of posting.

  • joshnystrom Profile Picture
    262 on at

    Okay, I've done more investigation on what is possible with this approach and here is a (hopefully) simple rollup:

    You can reliably clear Person, Choice and Lookup (but still not Date) fields as follows:

    Set each corresponding "blank" variable (Person is a Table, the others are individual Records)

    Set(
     BlankPeople,
     Table(
     {
     Claims: Blank(),
     DisplayName: Blank(),
     Email: Blank(),
     Department: Blank(),
     Picture: Blank(),
     JobTitle: Blank()
     }
     )
    );
    Set(
     BlankChoice,
     {
     Id: -1,
     Value: Blank()
     }
    );
    Set(
     BlankLookup,
     {
     Id: -1,
     Value: Blank()
     }
    )

    And merge-patching the target list item like so:

    Patch(
     'Test List',
     {ID: ItemID},
     {
    	 MultiPersonField: BlankPeople,
     ChoiceField: BlankChoice,
     LookupField: BlankLookup
     }
     )

    That's all I have so far. I still haven't tested Groups but I suspect they would work fine.

    Good luck!

    Josh

    E: In this thread - https://powerusers.microsoft.com/t5/Building-Power-Apps/Clearing-out-people-picker-field/m-p/258564#M75642 - my testing clarified that Date and single-Person fields were still reliant on the experimental feature, at least at the time of posting.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @joshnystrom this would be great if I could get it to work 😮

    I am currently receiving the following on my patch though:

    The type of this argument 'AssignedTo' does not match the expected type 'Record'. Found type 'Table'.
    The function 'Patch' has some invalid arguments.

    Any ideas?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Ah looks like the table is for where the person field allows more than one selection. Still cant update wherby allo multiple choice is disabled.

  • LavaJones Profile Picture
    5 on at

    Thanks Manojmittal! This worked for me. I can now clear the Person column.  

  • cbristol Profile Picture
    75 on at

    I don't understand it, but this totally worked. Thank you!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard