@Dondearie ....store that value in a variable and using split function in regular expression (split by semi-colon ";") store it in a collection and using for loop and the collection you can store it in a single line text variable and manipulate as per your need.

Thank you @kunalpatel. That helped buy I noticed that rather than removing just one item from the column all but one was left. Let me try to break this down more.

- I have 2 People Columns, ColumnA has multiple names and ColumnB has just one.

- I have a Query list that queries ColumnA and ColumnB and stores the values  for ColumnA in a string variables (strColA) and that of ColumnB in a collection variable (colColB)

- Next I have a RegEx that splits strColA by semicolon (;) and stores the value in a collection (colColA)

- Then a For each with target collection colCoA and the value stores in a string variable (strColA2) 

- Next is a Collection operation with Target collection colColB and Remove by value strColA2

- And an Update item that updates a third People column (ColumnC) with strColA2.

The value in Column C is accurate, however rather than reducing the entries in ColumnA by 1, it leaves just 1 entry.

What am I missing, please?

@Dondearie ...try below approach:

• Query your list for IDs (apply your filters and sorting if any) and store IDs in collection


• Also create 2 more collections i.e. for Column A and Column B
  
  
  
  • If you store it in string variable it will store the first applicable value
  
  
  
  


• Now use ID collection and for loop, get the index value in number variable
  
  
  
  • Use 2 collection operations and above index variable and get column A and column B values and store it in respective string variables
  
  
  
  

Use above variables for manipulation and get your desire outcome.

@Dondearie ...if you are trying to run the workflow on list items and you need to manipulate current item's column A then you can just use set variable to store the value in string variable and use RegEx.

@kunalpatel 

Thank you for your prompt response.

Can you throw more light on the statement "Now use ID collection and for loop, get the index value in number variable", please?

I have been able to figure this out. Thank you.

i know its an old tread but can you send us your fix, trying the same thing here.