Add new item (Sharepoint)

Help Activities
, , ,
1

Hello,

values are not being written in SharePoint, i use function Add New Item.

I take data from Excel and create DataTable (its in official UiPath manual), when i try to add data to sharepoint i have error.

1
1626×593 69.4 KB

2

2
2637×507 25.4 KB

3

3
3969×652 222 KB

4

4
41218×602 188 KB

5

5

6

@Svyatoslav_Guryanov

if you are adding only one single item, then the value field should in Object format and not string
Also the field should contain the field name from SharePoint and value should contain the value to be added

Hope this helps

cheers

7

Can you write an example of format?

Yes, single item

8

@Svyatoslav_Guryanov

You build datatable ypu have afield and value…both are given as string datatype…instead change the value column datatype to object

Along with that values are to be populated like this

In add datatow for example …you can ass the values or array row like this New Object() {"Status","Completed"}

This would be one row…similarly add all rows

Cheers

9

@Anil_G You mean I just need to change the data type in the data table?

10

@Svyatoslav_Guryanov

Yes that 1…I hope the field names are correct as per sp…because in the screenshot I see numbers in the field column

Cheers

11

i try this, nd i cannot build data base :frowning:

1

12

2

13

@Svyatoslav_Guryanov

Field shpuld be of type string

Cheers

14

i change field to string and value to object but still not work

15

@Svyatoslav_Guryanov

Can you pelase tell what is not working?

Cheers

16

its not working on “compose database for new item” stage

17

@Svyatoslav_Guryanov

Why noy use add data row activity…

Can you show your code please for adding

Cheers

18

image
image550×590 104 KB

19

@Svyatoslav_Guryanov

Use …add(New Object() {"value1",currentRow(0)})

Cheers