Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Behaviour of the SharePoint list People Picker column. Previous value is retained in case the value of control is updated to blank.Issue is same for all the dropdown columns

Hi All,

I have created a simple sharepoint list based app. In case the value of people picker  is updated to blank from any previous user name,the value of previous username is getting retained.This behaviour is causing confusion as the column is not mandatory but still due to the behaviour its getting treated as mandatory.

Community Support
Community Support

Hi @AdityaG :

Do you want to remove the user name when the value of people picker(Combo Box) is updated to blank?

According to your description, I learned that the value you want to remove is not in a required field(This point is very important).

Firstly, let me explain why you encountered this problem.

This is a robust design. If the combo box does not select any value, it will not update blank () to a value by default.

Secondly, I suggest you try this solution:

File - Settings - Experimental Features - Formula Level Error Management - On


Best Regards,


What I understand is that the behaviour is default and any columns with "Checkbox" should not be updated with blank value even if the columns are not mandatory

Hi @AdityaG

Would you tell me whether you tried the solution I provided?Has your problem been solved?

Best Regards,


Not really, I have used a workaround where I made the peoplepicker field required.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (70,019)