Supported Windows SharePoint Services Column Types

Article
02/02/2021

This topic describes the Windows SharePoint Services column types that are supported by the Windows SharePoint Services adapter. The values of these column types can be set in the message.

Note

Calculated columns are not updated by the adapter.

Supported types

The following table describes the supported column types:

UI Type	SharePoint Object Model Type	Sample	Comments
Single Line of Text	SPFieldType.Text	single line	None
Multiple lines of text	SPFieldType.Note	line 1 line 2 line 3	None
Choice Drop-Down	SPFieldType.Choice	ChoiceA	ChoiceA from the available choices (ChoiceA, ChoiceB, ChoiceC)
Choice Radio-Buttons	SPFieldType.Choice	#ChoiceB;#ChoiceC;#	ChoiceB and ChoiceC are enabled, ChoiceA is disabled (available choices are ChoiceA, ChoiceB, ChoiceC). Use ;# as a separator.
Number	SPFieldType.Number	123.456	None
Currency USD (or any other)	SPFieldType.Currency	100.00	None
Lookup	SPFieldType.Lookup	1	The number is the item identifier inside the referenced list.
YesNo	SPFieldType.Boolean	1	1=Yes 0=No
Hyperlink or Picture	SPFieldType.URL	https://www.microsoft.com, Microsoft Web Site	URL separated with "," from the display text. The "Microsoft Web Site" text will be a hyperlink to https://www.microsoft.com
Date and Time	SPFieldType.DateTime	2005-02-11T10:05:04	The DateTime as defined by the XML standard for the xs:dateTime. The pattern for dateTime is CCYY-MM-DDThh:mm:ss where CC represents the century, YY the year, MM the month, and DD the day, preceded by an optional leading negative (-) character to indicate a negative number. If the negative character is omitted, positive (+) is assumed. The T is the date/time separator and hh, mm, and ss represent hour, minute, and second, respectively. This representation may be immediately followed by a "Z" to indicate UTC or to indicate the time zone.

Supported Windows SharePoint Services Column Types

Supported types

See Also

Feedback

Feedback

Additional resources