c-kemme
Rookie

Get data from "request data action - task form"

Hi

I've created a list for employee onboarding.
The personnel department creates a new element(employee) in this list.
This triggers a workflow.
In this workflow is a Request data action.
It creates a task with a nintex task form to request data from the supervisor.
The form has a repeating section which contains a single list lookup field.
The list lookup field is not part of the onboarding list.
It is a custom field that looks up data from another list, which contains it-hardware.
The supervisor makes a selection of it-hardware the new employee will get.
Following the request data action, there is a create item in another site action.
This action should create an item in a list for it-hardware demand, and paste the content of
the repeating section from the nintex task form.
My issue is to get the data from the repeating section, to use it in the workflow.
I created a content type field (multiple lines of text)in the request data action,
connected it to a workflow variable and tried to fill it in the task form.
Sadly the wf variable keeps empty.
How can i access the data from the form in the workflow?

 

We are running Nintex Workflows & Forms Enterprise on Sharepoint Foundation 2013

 

regards
Christian

0 Kudos
Reply
3 Replies
kunalpatel
Collaborator

Re: Get data from "request data action - task form"

@c-kemme ....Follow below logic:

 

  • Create a MLT list column, make sure it's accepts only plain text
  • Now connect your repeating section to above MLT column
  • In workflow, run query XML and use MLT column as a source
  • Get all the fields you want and store it in collection
  • Run for loop on one collection and get index value
    • For other collections, using collection operations and index value get the values from each collections
    • Create item in child list, below 2 points if you don't want to create duplicates in child list
      • Get current item's ID & URL and store it in child list
      • Put a calculated/SLT control in rep section (make sure it's always disable) update it with child item's ID using update XML action
      • This way, you can create item in child list only if this control is empty
0 Kudos
Reply
c-kemme
Rookie

Re: Get data from "request data action - task form"

Hi @kunalpatel 

thanks for the answer.

Can you explain the following steps in more detail, please?

  • In workflow, run query XML and use MLT column as a source
  • Get all the fields you want and store it in collection
  • Run for loop on one collection and get index value

Do you have an example how the XML query action and collection action should look like?

 

0 Kudos
Reply
kunalpatel
Collaborator

Re: Get data from "request data action - task form"

  • Create a MLT list column and make sure it's plain text only
  • Now on your form, connect the repeating section to the above MLT column
  • In your workflow, use the above column as a source and get all the collections (seperately). You can use XPATH builder to select each controls
  • You don't have to query again in a for loop. Just create collections in first query XML action
  • Now take one collection and use it in For loop
  • Create a number variable "num_Index" and use that to get Index in For loop action
  • Now using collection operation and index value, get individual values of other collections for the index the for loop is running currently for
  • You can then use the individual values as per your needs
0 Kudos
Reply