Unable to get contents from O365 list Activity

[Joshua_Allan_0 (Joshua Allan)]

I am using the Microsoft Office 365 Activity to access a SharePoint List.
I have used the for each list to get all of the lists within my SharePoint site, outputting the name and list ID.
I have then been able to query a particular list and return back the correct number of index’s.

What I can’t seem to do whilst using the For Each List Item command is get the contents of each item outputted. The documentation isn’t clear if you can even get the content from this command. Anyone had any experience and able to help?

[Palaniyappan (Forum Leader)]

Hi

Are you referring to the same as in this thread

How to retrieve data from Sharepoint ReadListItems 2D dictionary

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] My code: [image] [image] The validation error says, Option strict …

Cheers @Joshua_Allan_0

[Joshua_Allan_0 (Joshua Allan)]

I am using this activity ( Microsoft Office 365 - RPA Component | UiPath Marketplace)

ChosenList is the output from Get List Info and is connecting.

My Output appears as follows:

So its able to get the 3 items it should with the correct status as per the filter, but I just don’t know how to get the values out from the list.

[Yoichi]

Hi,

I recommend to use Dictionaty to extract content of ListItem.

First, create Dictionary<string,object> in ForEachListItem as the following

dict = ListItem.Fields.ToDictionary(Function(x) x.Name, Function(x) x.Value)

Then, for example,

dict("LinkTitle").ToString

returns value of LinkTitle.

We can also get list of key from dict.Keys

Hope this helps you.

Regards,

[Joshua_Allan_0 (Joshua Allan)]

@Yoichi Amazing, thanks for that! Its working.