I have a column of People or Group Type that accepts multiple entries. How can I remove a single name from the others using Nintex workflow?
Solved
Remove a name from a multiple people or group column using workflow
+3Best answer by kunalpatel
@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.
+12@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.
+3Thank 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?
+12@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.
+12@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.
+3Thank 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.