Sharepoint List Items Help

[GlennRoberts]

Hi there hope someone can assist.

I am currently attempting to read List Items from a Sharepoint List which I want to refine before adding to a queue.

I have successfully connected to the appropriate Sharepoint list but it returns the variable type UiPath.MicrosoftOffice365.Models.Office365SharepointListItem.

I am unable/unsure how to to convert that to string or iterate through the fields so that i can gather the information from the list. I know that I could access the field by providing the index but I am needing 40+ fields from the list so that it can be input into another system.

If anyone has any experience or information that may be useful it would be appreciated.

[Yoichi]

Hi,

The following might help you.

Unable to get contents from O365 list Activity

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,

Regards,