Solved

Retrieve data of various item from a multiple line items (or csv)


Hi There,

Using Nintex Forms my users are selecting some items (multiple choice lookup).

Then the Workflow need to complete the details of each item to send a complete list to a responsible.

For example :

In Nintex Forms from UserSelections list I populated the 3 columns as follow (3rd one beeing the lookup from ProdSelectable) :

  • 1; Paul; "Apple, Nuddle, Bread"
  • 2; Mary; "Apple, Candy, Onion" 

ProdSelectable is made of 4 columns as follow :

  • 1, Apple, Gary Producer, London
  • 2, Nuddle, Gary Producer, London
  • 3, Bread, Tom Leaving, Paris
  • 4, Candy, Jerry Sams, New York
  • 5, Onion, Tom Leaving, Paris

The needed result is a message to myself saying :

  • Paul ordered :
    • Apple from Gary Producer in London
    • Nuddle from Gary Producer in London
    • Bread from Tom Leaving in Paris
  • Mary ordered :
    • Apple from Gary Producer in London
    • Candy from Jerry Sams in New-York
    • Onion from Tom Leaving in Paris

I could easily make the first steps, but I am struggling retrieving the details from ProdSelectable in the message.

I could not get a collection variable to be filled in and the string variable which contains my products IDs (1,2,3 for the first and 1, 4, 5 for the 2nd) couldn't be linked to send correct details.

I am missing something, can someone help ?

Working on Sharepoint 2019 with related Nintex Forms+Workflow versions.

Thanks a lot in advance.

icon

Best answer by Chris_GE 14 April 2022, 07:55

View original

3 replies

Userlevel 3
Badge +8

Hi @Chris_GE ,


 


What you need is a site workflow to run manually or schedule depending on when and how often the responsible need to receive the list orders (hourly, daily, etc.).


 


You will need the Query list action to retrieve the users selections and products details.


 


As example, the 2 lists I implemented are as below :




 


The Products lookup field is configured to get the ID which is not shown on the list view but only the Title.



 


The workflow will then query the list of User Selections then for each product selected, query the Products and build the final message as below :


 



 


The workflow look like this.



For each user, you will get the User Name and Products IDs, and retrieve product information.


 


Attached the workflow export of the example.


 

Hi @cecilia-penha,
Thanks a lot indeed for this complete answer, I'll try and let you know the result here 🙂

It just worked perfectly 🙂


Thanks a lot indeed and happy Easter (if you celebrate it).


 

Reply