AnsweredAssumed Answered

Count items within a collection

Question asked by mai-kel on Jul 28, 2017
Latest reply on Jul 28, 2017 by mai-kel

Hi community,

 

I have a problem with counting items within a collection (there are three items in that collection), and I am already getting mad about this. I tried three different approaches:

 

First try (Regular Expression):

 

RESULT
colFachabteilungen: ["{\"__metadata\":{\"type\":\"Collection(Edm.String)\"}","\"results\":[\"Fachabteilung 1\"","\"Fachabteilung 2\"","\"Fachabteilung 3\"]}"]

 

Count items object used:

RESULT
intAnzahlFachabteilungen: 4

 

 

Second try (Query List):

 

RESULT
colFachabteilungen: [["Fachabteilung 1","Fachabteilung 2","Fachabteilung 3"]]

 

RESULT
intAnzahlFachabteilungen: 1

 

 

Third try (List Lookup):

 

RESULT
colFachabteilungen: {"__metadata":{"type":"Collection(Edm.String)"},"results":["Fachabteilung 1","Fachabteilung 2","Fachabteilung 3"]}

 

Count items object used:

RESULT
intAnzahlFachabteilungen: 2

 

 

So I received "4", "1" and "2" whereas it should be THREE!!!!!

Aaaaaaaaaaaaaahhhhhhh.........

 

PLEASE tell me what I am doing wrong.

 

PS: I am using nintex for o365

collection operation

count elements

Outcomes