Multi-value column value confusion

  • 9 July 2019
  • 1 reply
  • 8 views

Badge +1

I am recreating a workflow for a SPonline list and Nintex.   

 

In SP2013 using Nintex I was able to copy the value of a multi-value choice column into a variable and paste it into a text field using only 2 actions (Set-Variable and Set-FieldValue) and  and get a nicely formatted string of text that looked like this:

 

Brazil;Ecuador

 

When I try to to the same thing in SharePoint online with Nintex I get this:

{"results":[{"Id":36,"Value":"Brazil"},{"id":8,"Value":Ecuador"}]}

 

I am using the same workflow actions:

 

How on earth can I make it work like it used to?  Each item will have a varying number of entries in the variable, so I would need to be able to clean up each one if I have to go that route.  I need to use the cleaned up string in a Powerapp.

 

@vadim_tabakman 


1 reply

Userlevel 6
Badge +22

Hi,


This post appears to be in the Nintex Workflow Cloud section but it looks like you are referring to Nintex for O365.
This solution can be acheived by using the update list item action.



Configuration:
Select the Single lines of Text column you require the metadata to be updated to.
Click the advanced lookup link and choise your Multi Choice column.



Click the X at the end of the field to alter the return type and select the Choices,Comma Delimited option.



When you update the Single lines of text column in this manner you will acheive the results you were after.


 

Reply