Home

SharePoint modern list form with optional lookup column couldn't be cleared/reset

%3CLINGO-SUB%20id%3D%22lingo-sub-357330%22%20slang%3D%22en-US%22%3ESharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357330%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20clear%20i.e.%20reset%20the%20value%20to%20blank%20for%20an%20optional%20lookup%20column.%20We%20have%20a%20list%20with%20lookup%20column.%20This%20column%20is%20set%20as%20optional.%20However%2C%20while%20creating%20new%20item%20as%20well%20as%20updating%20an%20existing%20item%2C%20if%20a%20User%20selects%20an%20option%20in%20Lookup%20column%2C%20user%20can't%20clear%20that%20option.%20There%20is%20no%20way%20to%20reset%20the%20column%20value%20back%20to%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIssue%20only%20occurs%20in%20modern%20experience.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357330%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elookup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394784%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F79705%22%20target%3D%22_blank%22%3E%40Gurdev%20Singh%3C%2FA%3E%26nbsp%3BWe%20just%20opened%20a%20support%20ticket%20with%20MS%20Support%20and%20we%20were%20told%20this%20is%20not%20supported%20in%20modern%20UI.%20It's%20a%20simple%20function%20that%20has%20been%20working%20on%20classic%20SP%20for%20many%20years%20and%20now%20they%20tell%20us%20not%20supported%20instead%20of%20trying%20to%20get%20a%20fix%20from%20development%20team.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392868%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392868%22%20slang%3D%22en-US%22%3EIt%20looks%20more%20like%20they%20%22forgot%22%20to%20add%20this%20functionality%20to%20this%20type%20of%20column.%3CBR%20%2F%3EEither%20way%2C%20they%20should%20add%20it%20ASAP...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-368210%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CRANT%3EBug%2C%20as%20usual%2C%20from%20Microsoft%20modern%20UI.%20I%20can't%20understand%20why%20Microsoft%20chooses%20to%20use%20their%20customers%20as%20software%20testers%2C%20as%20if%20we%20had%20nothing%20else%20to%20do.%20And%20I%20can't%20understand%20why%20we%2C%20customers%2C%20tolerate%20this%20behaviour%20from%20Microsoft.%20%3C%2FRANT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20I%20managed%20to%20workaround%20this%20problem%20by%20selecting%20the%20list%20item%2C%20clicking%20quick%20edit.%20Then%20SharePoint%20displays%20the%20list%20as%20a%20grid%2C%20where%20I%20can%20type%20%22delete%22%20key%20and%20remove%20the%20option.%20Hope%20this%20helps.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357893%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357893%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20adding%20a%20blank%20to%20the%20lookup%20list%20and%20order%20so%20its%20at%20the%20top.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20allow%20the%20user%20to%20select%20effectively%20a%20blank%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357882%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357882%22%20slang%3D%22en-US%22%3E%3CP%3EYep...Can%20do%20in%20Quick%20edit%20view%20by%20deleting%20the%20selected%20value%20for%20lookup%20column.%20However%2C%20this%20isn't%20a%20user%20friendly%20solution%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EImagine%20a%20user%20filling-out%20a%20big%20form%20to%20create%20a%20new%20list%20item.%20If%20this%20user%20by%20accident%20or%20intentionally%20selects%20a%20value%20for%20lookup%20column%20then%20there%20will%20be%20no%20way%20to%20clear%20this%20value%20unless%20the%20user%20cancels%20the%20form%20and%20start%20again%20or%20save%20it%20anyway%20and%20ask%20an%20admin%2Fpower%20user%20to%20clear%20it%20for%20him.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357414%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20modern%20list%20form%20with%20optional%20lookup%20column%20couldn't%20be%20cleared%2Freset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357414%22%20slang%3D%22en-US%22%3ESeems%20to%20be%20a%20bug...did%20you%20try%20to%20update%20the%20column%20using%20the%20quick%20edit%20option%20in%20the%20list%3F%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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.

6 Replies
Highlighted
Seems to be a bug...did you try to update the column using the quick edit option in the list?
Highlighted

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.

 

 

Highlighted

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 :)

Highlighted

<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. 

Highlighted
It looks more like they "forgot" to add this functionality to this type of column.
Either way, they should add it ASAP...
Highlighted

@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.

Related Conversations
Working with excel in Sharepoint desktop app
IanH1 in SharePoint on
2 Replies
Can you Please turn THIS into THIS?
HotCakeX in Discussions on
18 Replies
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Share Button added to the Toolbar!
HotCakeX in Discussions on
13 Replies