How to read a Sharepoint List

Hi all, I’m trying to read a Sharepoint List, within Ms office 365 Scope, but not sure how to declare the List and what other settings do I need. Any suggestion ? Attached what I have so far…

Hi,

The following might help you.

Regards,

wow, thank you so much. May I ask you how did you declare the dictionary in the part ToDictionary(of Int32,String) ?

I’ve tried this way, but it didnt work.

Hi,

The following post will help you.

Regards,

Hi gain, thanks a lot for the reply.
Unfortunately , still not getting the Sharepoint List . I would like to retrieve the headers and the Column Values , but instead I’m getting as attached below.
results

Hi,

For now, can you try the following steps?

First, create dictionary from ListItem.

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

Then, output content of dict.Keys using String.Join(",",dict.Keys)

We need to use one of the above result as key. If there is no key which you want to get, it might be difficult to achieve it by this way.

Regards,

1 Like