Item collection

[Sira]

Hi , i have a for each loop where it reading data from excel sheet to add on queue. But I am unable to add each row. I have an assign . If i use item collection its giving me error for variable type. Item collection is also not reading the row right. Thanks

[vrdabberu (Varunraj Dabberu)]

Hi @Sira

Can you share the screenshot of the flow where you are getting the error.

Regards

[Sira]

[vrdabberu (Varunraj Dabberu)]

Hi @Sira

Can you share what is the syntax you are giving in Add Queue Item Collection.

Regards

[Sira]

[Sira]

Its supposed to read from the excel sheet . Not sure if the variable is wrong
I have that as system. Collection. Gerneric. Dictionary-system.strung. System .data. Datatable

[vrdabberu (Varunraj Dabberu)]

Hi @Sira

Can you try the below syntax in Item Collection

dttable.AsEnumerable().ToDictionary(Function(r) r("item_status").ToString(), Function(r) CType(r, Object))

Regards

[Sira]

What will the assign variable type be

[vrdabberu (Varunraj Dabberu)]

It will be Dictionary(String, Object) @Sira

Regards

[Sira]

When i run its says