+7Hi,
I have a query that pulls in contents of a look-up column in a library. The library has 3 items. This query is working as intended since I tested it via debug procedure (Nintex Workflow history)
However, when I do a for-loop using following configuration, the 'New variable 4' is outputting blanks for 3 rows. I know the count is correct but why is this outputting blanks instead of the actual column-contents?
Any help is much appreciated!
Best answer by greenawayr
Make sure in your query that your Output Type is Separate Output per column.
If it isn't then the collection is formatted ["ColumnName":"Value";"ColumnName";"Value"] or something similar to this. The For Each doesn't recognise this.format. If you select Separate Output per Column then the output will just be [value1,value2,value3, value4] which the For Each will recognise.
+9Hi Shanan,
Any chance you could post the data/data structure that is returned in the initial collection?
Callum
Yes, I think we would need to se the actual Query action is set.
For example - you should have the Output type as Separate output per column (not Single output). This may cause blanks to appear (I seem to recall).
Make sure in your query that your Output Type is Separate Output per column.
If it isn't then the collection is formatted ["ColumnName":"Value";"ColumnName";"Value"] or something similar to this. The For Each doesn't recognise this.format. If you select Separate Output per Column then the output will just be [value1,value2,value3, value4] which the For Each will recognise.
+7Thanks shaunlub Ryan Greenaway! Both of your answers helped!
thanks for the offer to help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
