Build Datatable and Add to List in Sharepoint

[atarantino]

I retrieve an email, take all the data out of the body of the email and then build a data table using Build Data Table and Add Data Table Row. I write the data table to a range to make sure that the columns and data line up which they do. The problem is that after the process is complete i check SharePoint list and there is nothing there. I am never going to be updating i will only be adding to this list. When I build the data table the column headers are named the same as they are in SharePoint

I’m using the 0365 officially package. Any help would be great.

Build Data Table

o365 Scope

[Yoichi]

HI,

Field names of list should be set at not Column name but first row in the datatable, as the following

Add List Items

Regards,

[atarantino]

This was perfect. I missed that piece in the documentation for the sharepoint activity. I appreciate the help.

[skiiconnect (Sk. Imran Islam)]

Hi @Yoichi or @atarantino,
Thanks for discussing this topic.
I have a similar use case where I need to use “Add List Items” to add a new list item, to a Share Point list.
I have to fill 3 columns at the time of “Adding list item” and their “internal name” and “Type of data in the column” are mentioned below: -

Title = Text,
Business_x0020_Unit = Choice,
Business_x0020_Process_x0020_Own = Person or Group

In UiPath, I have created a data table using “Build Data Table” as shown in the image. But while running I’m getting error - “Add List Items: One or more columns of the provided DataTable is not of the correct type”.

Can you please check the image and the Share Point List column detail provided above and inform what will the the “Data Type” in “Build Data Table” in UiPath?