cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
rn5110
Nintex Newbie

How to create multi select checkbox items in a separate list?

Jump to solution

Hi,

I have 2 simple lists.

List A:

Title - Single line text

Skills - Multiple Choice

List B:

Title - Single line of text

Skill- Single line of text

I have been able to design a workflow to create multiple list items based on the List A's "Skills" column in List B.

Example:

List A:

Title                     Skills

Employee1          SharePoint;Nintex;SQL

Employee2          Nintex;SQL

List B:

Title                     Skills

Employee1          SharePoint

Employee1          Nintex

Employee1          SQL

Employee2          Nintex

Employee2          SQL

But the problem is whenever I tried to edit the item in List A and update it, it creates duplicates entries in List B.

I know I have to use the ID of List A to update List B's items but not sure where or how.

Can someone please help

Thanks.

0 Kudos
Reply
15 Replies
emha
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

add one another column in listB of type lookup and point it to listA ID coulm.

if it is ensured that in listA there is only one item per each employee, it could have been pointed listA Title field instead of ID, and you need not to store Employee name in listB Title column.

0 Kudos
Reply
rn5110
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

Thanks but your solution didn't work. Do I need to do anything on the workflow end?

0 Kudos
Reply
rn5110
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

Skills is List B.

0 Kudos
Reply
emha
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

yes, you have to fill in the lookup field in listB.

is 'QuizID' the suggested lookup list field in listB? if so then your create item action seems to be configured correctly (I assume workflow is running on listA).

what error do you get? or what's exactly not working?

0 Kudos
Reply
rn5110
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

Yes QuizID is the lookup of list B.

I dont get any errors. The items in list B doesnt get updated when I save an item in list B.

It keeps adding duplicate items to list B everytime I edit and save an item in list A.

Example:

List A:

Title                     Skills

Employee1          SharePoint;Nintex;SQL

Employee2          Nintex;SQL

 

 

List B: (see below)

Title                     Skills

Employee1          SharePoint

Employee1          Nintex

Employee1          SQL

Employee2          Nintex

Employee2          SQL

Employee1          SharePoint - Duplicate

Employee1          Nintex- Duplicate

Employee1          SharePoint- Duplicate

Employee1          Nintex- Duplicate

Employee1          SharePoint- Duplicate

Employee1          Nintex- Duplicate

0 Kudos
Reply
emha
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

could you share a screenshot of your workflow, to get a picture what exactly you do there?

how do you check for presence of respective item in listB? you should check by all 3 key field - QuizID + Title + Skills

0 Kudos
Reply
rn5110
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

I am not doing any kind of check right now. Here is the workflow.

0 Kudos
Reply
emha
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

ok, I see...

within the loop you have to first check listB (with query list action) whether there already exists respective item.

as mentioned above, query action should filter by all 3 key fields: quizID, tilte, skill.

then check with (eg.) run-if action whether the query returned any items or not. just in case it didn't returned any item you should create new item.

I'm not sure what's your real business case, but are you aware that this handles just cases when a new skill is added to an employee?

if a skill is removed from employees in listA, your workflow will not notice that it should remove it from listB.

0 Kudos
Reply
rn5110
Nintex Newbie

Re: How to create multi select checkbox items in a separate list?

Jump to solution

I want the workflow to update List B everytime the multi seelct checkboxes in List A changes, which includes addtions, updates and deletes.

What would you recommend? Sorry but this is my first Nintex worklfow so its still a huge learning curve for me.

0 Kudos
Reply