Get data from sharepoint list

How can I get data from a sharepoint list?

What component do I need to use?

@Rodrigo_Ferreira

Welcome to our UiPath community.

Install either UiPath.SharePoint.Activities or UiPath.MicrosoftOffice365.Activities package. We have multiple activities in this package to work with SharePoint.

Hi

Welcome to uipath forum

Check these threads for more details and approaches

The component we will be using is this

Cheers @Rodrigo_Ferreira

Thank you so much for the help!!

Can you help me with one more thing?

I’m doing a foreach list item to get the column values… but it brings a string object like this:

Office365ListItemField[66]
{
Office365ListItemField
{
DisplayName=“Título”,
Name=“Title”,
ReadOnly=false,
Value=“Teste”
},
Office365ListItemField
{
DisplayName=“Nome da Empresa”,
Name=“NomedaEmpresa”,
ReadOnly=false,
Value=“Teste”
},
Office365ListItemField
{
DisplayName=“Localidade”,
Name=“Localidade”,
ReadOnly=false,
Value=“São Paulo”
},
Office365ListItemField
{
DisplayName=“Endereço”,
Name=“Endere_x00e7_o”,
ReadOnly=false,
Value=“Rua Paulo dos Santos Guilherme”
},

I’m trying to use Deserialize JSON but it’s not working… I think it’s because the format of the Object string above.

Is there a way to format this so I could be able to save column values on variables?

1 Like

Hi

  1. Read text file
  2. Deserialize json object - outputVariable - VariableType(Newtonsoft.Json.Linq.Jobject)
  3. outputVariable(“Office365ListItemField”)(“DisplayName”).ToString

For Name
outputVariable(“Office365ListItemField”)(“Name”).ToString

For ReadOnly
outputVariable(“Office365ListItemField”)(“ReadOnly”).ToString

For referral

Hope this would help you resolve this issue

Cheers @Rodrigo_Ferreira

Hi @Rodrigo_Ferreira ,

I strongly suggest to look at Office365 activities specifically for SharePoint lists.

Here is a sample xaml to show how to get, iterated and update values in it.

https://forum.uipath.com/uploads/short-url/yeO1X4gSUa1mscAnwUXh7D6UuD7.xaml

Hi all, I am working with Rodrigo Ferreira in a little project and our scenery is: Get all data from a Sharepoint List and fill the fields in other website with Sharepoint info. The connectivity is already done with Sharepoint and we are already being able to see the list information but unable get the info to place in another site. Any ideia how do that?

Thank you