Feb 26 2019 04:52 PM
Is there a way to clear i.e. reset the value to blank for an optional lookup column. We have a list with lookup column. This column is set as optional. However, while creating new item as well as updating an existing item, if a User selects an option in Lookup column, user can't clear that option. There is no way to reset the column value back to blank.
Issue only occurs in modern experience.
Feb 26 2019 10:34 PM
Feb 27 2019 01:17 PM
Yep...Can do in Quick edit view by deleting the selected value for lookup column. However, this isn't a user friendly solution at all.
Imagine a user filling-out a big form to create a new list item. If this user by accident or intentionally selects a value for lookup column then there will be no way to clear this value unless the user cancels the form and start again or save it anyway and ask an admin/power user to clear it for him.
Feb 27 2019 01:29 PM
Try adding a blank to the lookup list and order so its at the top.
This will allow the user to select effectively a blank :)
Mar 13 2019 11:18 AM
<rant>Bug, as usual, from Microsoft modern UI. I can't understand why Microsoft chooses to use their customers as software testers, as if we had nothing else to do. And I can't understand why we, customers, tolerate this behaviour from Microsoft. </rant>
Anyway, I managed to workaround this problem by selecting the list item, clicking quick edit. Then SharePoint displays the list as a grid, where I can type "delete" key and remove the option. Hope this helps.
Apr 02 2019 02:57 AM
Apr 04 2019 10:16 AM
@Gurdev Singh We just opened a support ticket with MS Support and we were told this is not supported in modern UI. It's a simple function that has been working on classic SP for many years and now they tell us not supported instead of trying to get a fix from development team.