Hello all, I am currently running Sharepoint 2016 with Nintex Forms 2016 (4.6.2.0)
In one of my sharepoint lists I have a lot of lookup and managed metadata columns. For reasons irrelevant to the question here, I need to change as many of the former to single text or choice columns as possible.
For single text columns I can achieve this, by using a list lookup control in forms which get data from different source lists and assign selected choice as text to the single text column. This works as intended for single choice lookup columns, since I in Sharepoint View I can still filter the column by those choices.
However, if I have multi-select lookup column, the result is a comma-separated value. Let’s say, from a list with choices “A”, “B” and “C” - I would select “A” and “C”. The single text column then contains a text value: “A; C”. Filtering this column in a sharepoint view gives me then not the choices “A” and “C” as it would be in a proper lookup column, but a choice “A; C” which of course is not usable.
A solution for this problem would be to use a (not prepopulated) choice column instead of a single text column. However, a list lookup control in Nintex form does not allow me to save text to a choice column. Or at least I didn’t find how to do it.
Is there any way to achieve this?
Thank you in advance!