Can't change lookup column value back to "none" in modern experience

%3CLINGO-SUB%20id%3D%22lingo-sub-394792%22%20slang%3D%22en-US%22%3ECan't%20change%20lookup%20column%20value%20back%20to%20%22none%22%20in%20modern%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394792%22%20slang%3D%22en-US%22%3E%3CP%3EList%2Flibraries%20that%20has%20lookup%20column%20which%20points%20to%20another%20list%2Flibrary%20works%20as%20expected%20either%20in%20classic%20or%20modern%20experience%20except%20when%20you%20need%20to%20clear%20the%20value%20in%20lookup%20column%2C%20there%20is%20no%20option%20in%20modern%20experience.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-394792%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394796%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20change%20lookup%20column%20value%20back%20to%20%22none%22%20in%20modern%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394796%22%20slang%3D%22en-US%22%3E%3CP%3EAccording%20to%20MS%20Support%20it%20is%20not%20supported%20in%20Modern%20UI%20and%20we%20will%20need%20to%20use%20the%20classic%20mode%20for%20all%20libraries%20back%20to%20classic%20mode.%20I%20wasn't%20expecting%20that%20answer%20from%20MS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20thought%20about%20adding%20a%20blank%2Fnone%20record%20on%20each%20library%20that%20is%20being%20used%20as%20lookup%20column%20but%20that%20won't%20work%20for%20our%20environment%20because%20many%20lookup%20fields%20are%20pointing%20to%20the%20ID%20which%20is%20not%20editable%20(i%20would%20need%20to%20choose%20a%20specific%20id%20like%200%20or%20100%20for%20each%20library%20so%20everyone%20knows%200%20or%20100%20means%20%22none%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-674926%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20change%20lookup%20column%20value%20back%20to%20%22none%22%20in%20modern%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-674926%22%20slang%3D%22en-US%22%3EThanks%20for%20posting%20what%20you%20hear%20back%20from%20MS%20Bikash.%20That%20is%20a%20really%20disappointing%20answer%20from%20MS.%20I'm%20going%20to%20assume%20%2F%20hope%20that%20they%20will%20fix%20this%20soon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715558%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20change%20lookup%20column%20value%20back%20to%20%22none%22%20in%20modern%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715558%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35909%22%20target%3D%22_blank%22%3E%40Bikash%20Maharjan%3C%2FA%3E%2C%20I%20have%20posted%20this%20to%20uservoice.%26nbsp%3B%20Need%20to%20get%20more%20votes%20and%20then%20MS%20might%20take%20notice%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F37989157-allow-a-lookup-column-to-be-cleared-or-set-back-to%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F37989157-allow-a-lookup-column-to-be-cleared-or-set-back-to%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

List/libraries that has lookup column which points to another list/library works as expected either in classic or modern experience except when you need to clear the value in lookup column, there is no option in modern experience. 

 

 

3 Replies
Highlighted

According to MS Support it is not supported in Modern UI and we will need to use the classic mode for all libraries back to classic mode. I wasn't expecting that answer from MS.

 

I also thought about adding a blank/none record on each library that is being used as lookup column but that won't work for our environment because many lookup fields are pointing to the ID which is not editable (i would need to choose a specific id like 0 or 100 for each library so everyone knows 0 or 100 means "none")

Highlighted
Thanks for posting what you hear back from MS Bikash. That is a really disappointing answer from MS. I'm going to assume / hope that they will fix this soon.
Highlighted