How to retrieve data from Sharepoint ReadListItems 2D dictionary

#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
image.png532×529 76.1 KB

My code:
image
image

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:

#8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.