Contents
- Available formats for SharePoint field types
DocTrix WorkFlow for Office 365
- Add Item to Collection
- Build Dictionary
- Calculate Date
- Calculate Value
- Clear Collection
- Count Items in Collection
- Find Interval Between Dates
- Format DateTime
- Get Item from Collection
- Get Item from Dictionary
- Join Items in Collection
- Regular Expression
- Remove Duplicates from Collection
- Remove Item from Collection
- Remove Value from Collection
- Replace Value in Collection
- Set Variable
- Set Workflow Status
Available formats for SharePoint field types
DocTrix WorkFlow for Office 365 >
Data types and inputs > Lookup dialog > Lookup format > Available formats for SharePoint field types
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. |
||