How to retrieve data from Sharepoint ReadListItems 2D dictionary

Learning Hub Academy Feedback
1

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:

image
image532×529 76.1 KB

My code:

image
image446×427 8.39 KB

image
image370×363 6.81 KB

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.

2

@kavyashreeh22 What’s the type of item?

3

Listitems is Dictionary of string, object

4

:sweat_smile: Can you send the screenshot of Properties of For each

5

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

6

@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?

7

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