You are viewing limited content. For full access, please sign in.

Question

Question

Retrieve BP Variables not recognizing table rows

asked on September 20, 2017

I have a form process that invokes a workflow which retrieves the form variables and then performs a "for each row" action on one of the tables.  The first time I ran this workflow it worked perfectly; however, now it does not recognize that there are rows in the table.  When it gets to the For Each Row activity, it says there are zero iterations.  Also the retrieve business process variables tokens are blank for all tables in the form when I look at the token tracking data in Workflow. For other variables, the token values are accurate, only the tables are empty.

I've tried refreshing the retrieve business process variables activity, to ensure that the table name references are accurate, and checked the submission id to make sure it is looking at the correct form, with no change in the results.

Any suggestions you have for troubleshooting this would be greatly appreciated!  

WF Design.png
WF Token Results.png
Forms Layout with Variables.png
WF Design.png (155.38 KB)
0 0

Answer

SELECTED ANSWER
replied on September 22, 2017 Show version history

So with the help of my VAR I was able to resolve this issue.  The problem was that I had failed to choose a qualifier for the lookup rule that was populating the table in the form.  This was causing a significant number of blank rows to display in the table.  I hid those rows using field rules; however, those blank rows still existed when the form was submitted even though they were hidden.  These blank rows caused an issue when workflow tried to retrieve the table rows.  Once we included a qualifier for the lookup table that caused the empty rows to not ever populate into the table, the workflow was able to run successfully.  It now finds all appropriate iterations and runs through each one of them in the For Each Row activity as desired.

0 0

Replies

replied on September 21, 2017

You can use For Each Value - Choose a Value that always be completed say drop_date

Reference each variable as (%variablename#[foreachvalue_interation]#)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.