Get data from sharepoint list

Help Studio
, ,
1

How can I get data from a sharepoint list?

What component do I need to use?

2

@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.

3

Hi

Welcome to UiPath forum

Check these threads for more details and approaches

The component we will be using is this

Cheers @Rodrigo_Ferreira

4

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
5

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

6

Hi @Rodrigo_Ferreira ,

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

https://docs.uipath.com/activities/docs/office365-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

7

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

8

Hi @renato.cardia, welcome to the UiPath forum!

When you say another site? What type of site do you mean? If you are talking about some UI automation, I imagine you’ll be using to https://docs.uipath.com/activities/docs/set-text or Type Into activity to the “other” website.

9

Hi Tics robo, thanks for this help

Yes, I am using type into, however, I have some data in a sharepoint list and I’d like to get each value and put in a variable and in the target system where I would like to put the info gathered I need to get each varible and input the data in each field.

10

Hi @renato.cardia,

You have to give us more details here.

Which part exactly are you having trouble with?
Is it with getting the data?
Is it iterating the data?
Is it setting the data to the new site?

Plus some sample xaml or screenshots will be helpful too.

11

Hi All,

I am using the O365 activity to access my SharePoint lists. I have successfully connected and can see my lists, I have also sucesffully put a filter (“fields/Status eq ‘Pending’”) which is getting the 3 corresponding values in my SharePoint list.

I am having issues actually getting the fields within the list out though. I am basically after a JSON file exported with all the fields. How would I go about doing that?

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.