microsoft forms how to add a lookup field

%3CLINGO-SUB%20id%3D%22lingo-sub-151810%22%20slang%3D%22en-US%22%3Emicrosoft%20forms%20how%20to%20add%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151810%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20to%20add%20lookup%20field%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-151810%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-152295%22%20slang%3D%22en-US%22%3ERe%3A%20microsoft%20forms%20how%20to%20add%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-152295%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20reply.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151818%22%20slang%3D%22en-US%22%3ERe%3A%20microsoft%20forms%20how%20to%20add%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151818%22%20slang%3D%22en-US%22%3E%3CP%3EUnless%20I'm%20mistaken%2C%20there%20isn't%20a%20way%20to%20do%20this%2C%20and%20even%20if%20there%20was%2C%20it%20would%20be%20dangerous%20to%20do%20so%20due%20to%20what%20I%20consider%20a%20current%20flaw%20with%20how%20Forms%20handles%20submitted%20responses.%20We%20found%20that%20in%20the%20event%20that%20an%20option%20in%20a%20Choice%20field%20changes%2C%20say%2C%20B%20is%20edited%20to%20become%20C%2C%20every%20response%20that%20replied%20B%20turns%20into%20C.%20If%20Lookup%20were%20possible%2C%20and%20since%20those%20options%20can%20also%20change%2C%20I'd%20expect%20the%20same%20issue%20to%20occur.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

how to add lookup field

2 Replies

Unless I'm mistaken, there isn't a way to do this, and even if there was, it would be dangerous to do so due to what I consider a current flaw with how Forms handles submitted responses. We found that in the event that an option in a Choice field changes, say, B is edited to become C, every response that replied B turns into C. If Lookup were possible, and since those options can also change, I'd expect the same issue to occur.

Thanks for the reply.