Solved

For Each not capturing values


Badge +7

Hi,

 

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!

icon

Best answer by greenawayr 27 July 2017, 11:00

View original

4 replies

Badge +9

Hi Shanan,

Any chance you could post the data/data structure that is returned in the initial collection?

Callum

Badge +11

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).

Userlevel 6
Badge +13

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.

Badge +7

Thanks shaunlubRyan Greenaway‌! Both of your answers helped!

‌ thanks for the offer to help!

Reply