K2 Five create a string in a loop from SharePoint items

Just update your “append title” on the loop with a BASIC > Set Variables setting the value of the variable var_items to:

var_items-[Test-Items Item Titel]

where [Test-Items Item Titel] is the field from the current list item.

Good morning,

To put a fine point on this, the Join function is designed to take a list of items, so you pass in a property from a List SmartObject (in this case, the SharePoint SmartObject Title property), and the Join will concatenate that listed property with the separator of your choosing, so you don’t need to use a Loop.

You can read more about the inline functions here: Context Browser Functions

Now, if, for whatever reason, that approach doesn’t work, then the loop approach would be viable. The loop will create an item reference for the current item you are working with on your loop that you could then use in a set variable step to manually concatenate your values.

Hello ovs,

so I don’t need the join operator. Is that correct?

I get all the Titles in one string, but I want to add a separator like Text1;Text2;Text3. How can I do that?

Best regards

Matthias

This depends on the path you are using. If you are using a Loop, you don’t need the join and you will need to add the separator of your choosing to when you use the Set Variable event to build out your string. You will also need to account for ensuring that you aren’t left with a trailing separator character.

Alternatively, you can skip the loop all together and just the join function with the List Results of your SmartObject directly. 

But you will not use both the Join function and the Loop together.

Here is an example workflow using both the Join OR the Loop approaches.

I created a package and uloaded to my GitHub that illustrates how to do what you are asking either using the Join function OR using a loop.

K2-Help-Examples/String Concat Example at main · Case-IT-Solutions/K2-Help-Examples