Skip to main content
Nintex Community Menu Bar
Solved

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

  • April 7, 2022
  • 3 replies
  • 73 views
  • Translate

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.

Best answer by Chris_GE

Hi @cecilia-penha,
Thanks a lot indeed for this complete answer, I'll try and let you know the result here 🙂
View original
Did this topic help you find an answer to your question?

3 replies

cecilia-penha
Nintex Employee
Forum|alt.badge.img+8
  • Nintex Employee
  • 66 replies
  • April 13, 2022

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.

 

Translate

  • Author
  • 5 replies
  • Answer
  • April 14, 2022
Hi @cecilia-penha,
Thanks a lot indeed for this complete answer, I'll try and let you know the result here 🙂
Translate

  • Author
  • 5 replies
  • April 15, 2022

It just worked perfectly 🙂

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

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings