Lookup column - value not from linked list

%3CLINGO-SUB%20id%3D%22lingo-sub-2946472%22%20slang%3D%22en-US%22%3ELookup%20column%20-%20value%20not%20from%20linked%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2946472%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20add%20a%20value%20in%20a%20column%20that%20is%20using%20lookup.%26nbsp%3B%3C%2FP%3E%3CP%3Ee.g%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20lookup%20column%20that%20has%203%20values%26nbsp%3B%3C%2FP%3E%3CP%3Ebannana%26nbsp%3B%3C%2FP%3E%3CP%3Eapple%26nbsp%3B%3C%2FP%3E%3CP%3Egrape%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I%20can%20easly%20select%20one%20or%20multiple%20of%20these%20options%20that%20are%20linked%20to%20my%20fruit%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20however%20enter%20a%20unique%20value%20that%20is%20not%20from%20the%20original%20fruit%20list%20like%20%22pear%22%20without%20having%20to%20add%20a%20new%20item%20to%20the%20fruit%20list%3F%3C%2FP%3E%3CP%3ECheers%26nbsp%3B%3C%2FP%3E%3CP%3ESam%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2946472%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2946819%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20column%20-%20value%20not%20from%20linked%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2946819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1212094%22%20target%3D%22_blank%22%3E%40EKIT415%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20didn%C2%B4t%20specify%20what%20your%20working%20environment%20is%20but%20here%C2%B4s%20a%20suggestion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20two%20possibilities%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESharePoint%20standard%20listform%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3ELet%20the%20user%20select%20a%20value%20%22Other%22%20from%20the%20lookup.%3C%2FLI%3E%3CLI%3EIf%20%22Other%22%20is%20selected%20the%20user%20fills%20in%20a%20value%20in%20a%20textbox.%20This%20value%20is%20stored%20in%20a%20separate%20column.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThis%20option%20does%20not%20allow%20for%20logic%2C%20such%20as%20only%20showing%20the%20textbox%20when%20the%20%22Other%22%20lookup%20value%20is%20selected.%20For%20this%20you%20can%20create%20a%20%3CSTRONG%3EPower%20App%3C%2FSTRONG%3E%2C%20see%20attached%20image.%20You%20still%20need%20two%20columns%2C%20but%20the%20UI%20will%20be%20more%20user%20friendly%20and%20safe%20from%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22form.png%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325926i3493AEBFD5E39F4D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22form.png%22%20alt%3D%22form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2952856%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20column%20-%20value%20not%20from%20linked%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2952856%22%20slang%3D%22en-US%22%3EHi%20Maggan%2C%3CBR%20%2F%3ESorry%20I%20am%20using%20sharpoint%20and%20Microsoft%20lists.%3CBR%20%2F%3EI'm%20not%20sure%20how%20I%20can%20let%20people%20select%20other%3F%20Do%20I%20have%20to%20put%20other%20in%20the%20orgininal%20list%20that%20I%20am%20referencing%20for%20the%20lookup%20or%20is%20there%20an%20option%20somewhere%20that%20I%20am%20not%20aware%20of%20to%20put%20other.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20also%20having%20an%20issue%20when%20adding%20information%20from%20excell%2C%20if%20the%20value%20in%20this%20Lookup%20column%20doesnt%20match%20any%20of%20the%20values%20from%20the%20origninal%20list%20i%20cant%20add%20it%2C%20is%20there%20a%20way%20around%20this%3F%3CBR%20%2F%3ECheers%3CBR%20%2F%3ESam%3C%2FLINGO-BODY%3E
Occasional Contributor

HI 

Is it possible to add a value in a column that is using lookup. 

e.g 

I have a lookup column that has 3 values 

bannana 

apple 

grape 

and I can easly select one or multiple of these options that are linked to my fruit list. 

 

Can I however enter a unique value that is not from the original fruit list like "pear" without having to add a new item to the fruit list?

Cheers 

Sam 

 

3 Replies

@EKIT415 

You didn´t specify what your working environment is but here´s a suggestion.

 

There are two possibilities:

 

SharePoint standard listform:

  • Let the user select a value "Other" from the lookup.
  • If "Other" is selected the user fills in a value in a textbox. This value is stored in a separate column.

This option does not allow for logic, such as only showing the textbox when the "Other" lookup value is selected. For this you can create a Power App, see attached image. You still need two columns, but the UI will be more user friendly and safe from errors.

 

form.png

Hi Maggan,
Sorry I am using sharpoint and Microsoft lists.
I'm not sure how I can let people select other? Do I have to put other in the orgininal list that I am referencing for the lookup or is there an option somewhere that I am not aware of to put other.

I am also having an issue when adding information from excell, if the value in this Lookup column doesnt match any of the values from the origninal list i cant add it, is there a way around this?
Cheers
Sam
You could add Other to the original list for simplicity. However, if you choose to create a custom form with Power Apps, the value Other can be just a control in the form with no connection to SharePoint data. When the user selects Other, a textbox for entering av value will be visible. This value will be stored in the SP list.

Regarding your other issue, Excel to SP: Are you using Grid view editing - copy/paste? You could exclude the column from the original source (Excel) and set the lookup value manually/bulk edit after copying it to SP.