Mapping SharePoint fields to UiPath fields

About

This page presents how SharePoint data fields are mapped to UiPath data fields.

Mapping

SharePoint field	UiPath field	Comments
Text	Type: String Widget: String
Choice Allow Multiple Choice	Type: String Widget: Dropdown Allow Multiple Choice Type: String[] Widget: Multiselect
Date and time Include Time	Type: DateTime Widget: DateTime Include Time Type: DateTime Widget: DateTime
Multiple Lines of Text	Type: String Widget: String
Person Allow selection of Groups Allow multiple selections	Type: Object – SharepointLookupValue("{Text presented}", "Id") Widget: Autocomplete Allow multiple selections Type: IEnumerable<Object> – SharepointLookupValues("{Text presented}", "Id") Widget: Multiselect
Number	Type: Decimal Widget: Number
Yes/No	Type: Boolean Widget: Bool
HyperLink	NOT MAPPED
Currency	Type: Decimal Widget: Number
Location	HALF MAPPED → No way to Insert or Update the column	Map each column of the location but not the location as object
Image	NOT MAPPED
Manage metadata Term only Term plus parents Allow users to type new values Multiple Values	NOT MAPPED
Lookup Allow multiple	Type: Object – SharepointLookupValue("{Text presented}", "Id") Widget: Autocomplete Allow multiple selections Type: IEnumerable<Object> – SharepointLookupValues("{Text presented}", "Id") Widget: Multiselect
Calculated	Mapped based on the type. Read only.	On SharePoint the datatype returned is based on how you set the column. The data type returned from this formula is: • Single line of text • Number (1, 1.0, 100) • Currency ($, ¥, €) • Date and Time • Yes/No
Task Outcome	NOT MAPPED
External Data	NOT MAPPED