topic Loop with collection in Product Forum

Loop with collection

LuiseDunkel — Wed, 24 Jun 2020 14:44:00 GMT

Hello everyone,

I need help with a loop in combination with a collection.

The collection contains data from an excel file - that works.

When starting the loop, it only processes the first row of my collection. But the loop shoul process every single row
(data input into a browser based application).

Do you have an idea?

Thank you so much!!

------------------------------
Luise Dunkel
------------------------------

RE: Loop with collection

peterlacken — Thu, 25 Jun 2020 07:40:00 GMT

Hi Luise,

i guess you are using the collection utility VBO to access the collection within the loop and this is resetting the counter back to 1. Use the calculation stages to access the collection content with the notation [collectionname.columnname]

Peter

------------------------------
PeterLacken
Ren Røros Intelligent Automation
Peter.Lacken@rria.no
http://www.rria.no
------------------------------

RE: Loop with collection

John__Carter — Thu, 25 Jun 2020 11:16:00 GMT

I'd 'sanity check' that you have set the loop with the correct collection, and that there aren't 2 collections with the same name.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Loop with collection

LuiseDunkel — Sun, 28 Jun 2020 18:32:00 GMT

Dear John, thanks for answering.
I ckecked the Loop in combination with the collection.
The loop works when I try to use it with a simple action (writing down the data of the collection into notepad).

Do you have an other idea?

------------------------------
Luise Dunkel
------------------------------

RE: Loop with collection

LuiseDunkel — Sun, 28 Jun 2020 18:36:00 GMT

Hi Peter,

thank you for answering me. The loop works when I try to use it with a simple action (writing down the data of the collection into notepad).

So, I can't imagine that there is a problem with the collection (utility VBO) or with the loop. Do you have another idea?

Thanks a lot!

------------------------------
Luise Dunkel
------------------------------