Nov 09 2021 11:08 PM
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
Nov 10 2021 12:51 AM
You didn´t specify what your working environment is but here´s a suggestion.
There are two possibilities:
SharePoint standard listform:
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.
Nov 10 2021 04:33 PM
Nov 11 2021 12:04 AM