Shaprepoint list data export

Help IT Automation
1

I need to export the SharePoint List Items into the Excel by using the UiPath,

Could you please help me with this ?

2

Hi @nithya.an
Use Get List Items activity to retrieve SharePoint list data, then use Write Range to export it to Excel.

For more :slight_smile:

If helpful, mark as solution. Happy automation with UiPath

3

Hi @nithya.an

You can consider below approach:

  1. Use get list items activity to get all the list items in a datatable.
  2. Then use write range activity to write the datatable into excel file.

If you dont want to write the list items directly onto excel but need to do some verifications/modifications first on the data retrieved, then use for each row in datatable activity, perform your steps. once done, write the datatable into excel.

Hope this helps.

4

I tried this But my data has arround 40k but it not working is thier any data size limit

5

Hi @nithya.an

What do you mean when you say not working?

You getting any error? or no data being written to the sheet?

Can you please show your workflow?

6

Like execution :job stopped error message,

is their any way to export the views

7

Hi @nithya.an

its really hard to understand and help you on the issue without proper details.’

Please share steps you have followed, along with screenshots and what activity you are getting.

8

I have sharepoint list containg 50k list Item and also I need to export that data into excel I am getting this below Error.

image
image677×276 8.88 KB

9

@nithya.an

which activity you are getting this error? are you getting right when execution is started? Or while trying to write to excel file?

10

writing back to the data to the excel

11

@nithya.an

In that case, I think memory overload is happening as you are trying write large volume of data at once in excel.

i would suggest to break down the data into chunks and write.

I am attaching example of flow, kindly refer the same.

12

Thank you for your reply but what if the data is refreshed on daily basis like today the list is having the 40k row and next day 41k

13

@nithya.an

You can define your chunk size dynamically based on number of rows in your datatable

for eg

chunk size = dt.rows.count/5