Contents
- Available formats for SharePoint field types
SharePoint Field Type | Available Formats | Format Examples |
---|---|---|
Person or Group |
Text |
8 |
Login Name |
i:0#.f|membership|a.braun@systemz.io |
|
Display Name |
Andrew Braun |
|
|
a.braun@systemz.io |
|
Lookup |
Dictionary |
{“Id”:4,”Value”:”Purchase Order”} |
As string |
{“Id”:4,”Value”:”Purchase Order”} |
|
Lookup Id |
4 |
|
Lookup Value |
Purchase Order |
|
Text |
Text |
Approval is required |
As boolean |
True |
|
As collection |
[“First”, “Second”, “Third”] |
|
As datetime |
3/14/2019 8:01:12 AM |
|
As dictionary |
{“Title”: “Purchase Order”, “Amount”: “10000”, “Confidential”: true} |
|
As guid |
bd9a4569-7520-4142-8209-c05b5faecef0 |
|
As integer |
25 |
|
As number |
43,26 |
|
To Lower Case |
approval is required |
|
To Upper Case |
APPROVAL IS REQUIRED |
|
The initial value (before formatting) must match to the selected format. |
||
Number |
String |
43,26 |
Number |
43,26 |
|
Integer |
43 |
|
Currency |
43,26 |
|
Boolean |
String |
True |
Hyperlink or Picture |
Dictionary |
{“__metadata”:{“type”:”SP.FieldUrlValue”},”Description”:”Google”,”Url”:”http://www.google.com”} |
String |
{“__metadata”:{“type”:”SP.FieldUrlValue”},”Description”:”Google”,”Url”:”http://www.google.com”} |
|
Choice |
Text |
Mail Delivery Type |
As boolean |
True |
|
As collection |
[“First”, “Second”, “Third”] |
|
As datetime |
3/14/2019 8:01:12 AM |
|
As dictionary |
{“Title”: “Purchase Order”, “Amount”: “10000”, “Confidential”: true} |
|
As guid |
bd9a4569-7520-4142-8209-c05b5faecef0 |
|
As integer |
25 |
|
As number |
43,26 |
|
To Lower Case |
mail delivery type |
|
To Upper Case |
MAIL DELIVERY TYPE |
|
The initial value (before formatting) must match to the selected format. |