How to retrieve data from Sharepoint ReadListItems 2D dictionary

[kavyashreeh22 (Kavyashree H)]

Studio/Robot version: 2018.4.4

@radu_bucur,

I’m trying to read sharepoint list items using the Sharepoint package activity, Read list Items.
Apparently, I’m able to read the list items, but I’m not able to fetch their data.

I have gone through the Sharepoint package documentation which easily says we can use for each loop and retrieve the data, which is not working for me. Am I missing something here?

Document:

My code:

The validation error says, Option strict on disallows late binding. I have not worked on 2D dictionary before and unable to find any correct solution on the internet.

[supermanPunch (Arpan)]

@kavyashreeh22 What’s the type of item?

[kavyashreeh22 (Kavyashree H)]

Listitems is Dictionary of string, object

[supermanPunch (Arpan)]

Can you send the screenshot of Properties of For each

[supermanPunch (Arpan)]

@kavyashreeh22 I guess you need to change the TypeArgument of For Each as a Dictionary<String,Object> If it’s already done, please ignore this.

[kavyashreeh22 (Kavyashree H)]

@supermanPunch, thanks. I was not using the correct type argument in for each loop.

Even then, I dont understand how to use this Read List items to get all the data from the list.
Has anyone used this? Can anyone send me an example xaml?

[supermanPunch (Arpan)]

@kavyashreeh22 Can you send your workflow if its possible? I can try to make the changes as per your requirement