Correct Data Type in "Build Data Table" to use in "Add List Items" activity of "Microsoft Office 365 SharePoint List

Help Activities
,
1

Correct Data Type in “Build Data Table” to use in “Add List Items” activity of "Microsoft Office 365 SharePoint List

Use Case Description

Hi all

I have a 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: -

  1. Title = Text,
  2. Business_x0020_Unit = Choice,
  3. 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 3 Share Point List column detail provided above and inform what will the the “Data Type” in “Build Data Table” in UiPath?

AS-IS WORKFLOW, TO-BE WORKFLOW

image.png
image.png1473×154 10.2 KB

Other information about the use case

Industry categories for this use case: Information Technology and Services, Insurance

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio

Other applications that were used: -

Other resources: -

What is the top ROI driver for this use case?: Increase employee engagement

2

What are the datatypes in the sharepoint list? My guess is they’re all just string.

3

Hi,
Following are the column name and data type.

4

That’s the type of field, defining what it does, but that’s not the same as a datatype. Just try string.

5

@skiiconnect

FYI

IMG_7296
IMG_7296828×830 148 KB

PersonOrGroup type cannot be a column type as you cannot set those values from UiPath as of now

You need to go with using graph api directly and also there as well we need to get the id of all people we need before setting

Cheers