When I do a for each in a Sharepoint list it skips empty columns

[daniel.canas]

Hello everyone.

I have a problem when I have used Sharepoint activities in Microsoft office 365 package. I get the list information with the “Get List Info” activity, subsequently it does a “For Each List Item” activity. I use “write line” ( listSharepoint.fields(3).Value.tostring) to go through the list, it works but when the column has no value it jumps to the next column and it is impossible to control the value I need for each column.

The number 1 in the output is other column because it has a empty column.

Regards.
Daniel

[Yoichi]

Hi,

I think it’s better to use not index but field name with dictionary, in this case. The following will help you to create dictionary for list items.

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,