Excel import multiple value field. Import as list reference

Hi All,   I am trying to import data from xls sheet using excel importer. One of the column is having  comma separated multiple fields. I want to store as a list reference. I tried using “parse with” microflow option in the excel template screen. But that does not seem to work. Can someone help with this.
1 answers


What you could do is use the StringSplit java action from the Community Commons module. This will allow you to split up the string into several splititem objects. Then you can process those into the correct entities and set them as a reference list.

Hope this helps!