Question

Populating a forms collection from workflow

Workflow

Updated December 20, 2018

asked on December 20, 2018 • Show version history

I have a form that calls a workflow that I want to populate a collection variable with a students current courses. I can't seem to figure out how to add multiple rows to the collection variable by iterating through the rows returned by the SQL query:

For starting variables I've tried to reference with things like Current_Courses.Course[%(ForEachRowincourses_Iteration)]=%(ForEachRowincourses_COURSE_NUMBER)

I've tried searching for the correct syntax but haven't been able to find anything.

0 0

Answer

SELECTED ANSWER

replied on December 20, 2018 • Show version history

Check this post. Basically, you just need to create a multi-value token for each column, then you set them all at the same time using the Set Business Process Variables activity.

Instead of looping on the variable update

create a multi-value token for each column before the loop
for each row, append the column value to the column token
after the loop use your column tokens to set the variables all-at-once

0 0

Replies

replied on December 20, 2018

Thanks, that was exactly what I was looking for!

0 0

You are not allowed to follow up in this post.

Question

Question

Populating a forms collection from workflow

Answer

Replies

Sign in to reply to this post.