Sharepoint columns and Nintex workflow : how to refill lookup column with new data from a task

  • 22 April 2022
  • 2 replies
  • 16 views

Dear all,

Due do management decision, a workflow that I wrote needs to be modified as follow :

  • in a list (a) from a nintex forms, I launch a nintex workflow which generate a approve/reject task;
  • in the task form, the user is choosing one2many items (apple, bread, fruit juice) from another list (b);
  • whether the task is approved or rejected is not really important, but the choice(s) of the user within the task (one2many of the list b) must be sent back to the original list (a).

For example :

  • from the list (a), I create a new request "which product would you be happy to order today ?" which contain my phone number and a comment column;
  • the workflow generates a task to the recipient allowing him/her to :
    • put a comment
    • choose one2many products from a list (this works pretty fine)
  • the workflow must then in the (a) list item :
    • update the username + comment (which is fully fine);
    • update also the lookup column related to the one2many choosen products

What I could not achieve is to refill this last element : give back on list (a) what was chosen on the task by the recipient.

 

Data examples :

List (a) columns :

- Whom | When             | What                                       | 

- Paul    | April-22-2022 | <empty>                                  |   

- Mary   | April-22-2022 | <empty>                                  |   

- Jerry   | April-22-2022 | <empty>                                  |   

- Paul    | April-21-2022 | Bread, Apple, Sparkling water |

- Jerry   | April-21-2022 | Apple, Orange                         |

- Mary   | April-21-2022 | Sparkling water                       |  

List b - source for the products :

- Apple                            | Jimmy grocery |

- Orange                         | Local market    |

- Sparkling water            | Jimmy grocery |

- Bread                           | Local market    |

- Nuts                             | Local market    |

Related task form :

- Whom | When             | What                                      |

- Paul    | April-22-2022 | Apple, Nuts                             |

- Mary   | April-22-2022 | Bread, Sparkling water           |

Returned result on the list a after Paul and Mary answered :

- Whom | When             | What                                       | 

- Paul    | April-22-2022 | Apple, Nuts                             |   

- Mary   | April-22-2022 | Bread, Sparkling water            |   

- Jerry   | April-22-2022 | <empty>                                  |   

- Paul    | April-21-2022 | Bread, Apple, Sparkling water |

- Jerry   | April-21-2022 | Apple, Orange                         |

- Mary   | April-21-2022 | Sparkling water                       |  

 

I've red some posts about using ;#;# but I must admit... I could not understand why and how.

 

Thanks a lot for your help on this :).

Chris


2 replies

Userlevel 5
Badge +13

Hi @Chris_GE 


 


I would like to talk through this use case with you and I don't think this thread would do it justice as I may be missing some points.


 


Please feel free to add me on LinkedIn and we can perhaps arrange a call.


 


Kind regards


Jake

Hi Jake,


Thanks a lot for this contact proposal. However, as you might not be the only one missing some elements, shall we complete the case here ? I'll be very happy to answer any of your questions.


Moreover I am a huge supporter of community forums where I can find more than 95% of my answers, it's kind of a team participation for me 🙂.


Looking forward reading from you.


Chris

Reply