SYSTEMZ Documentation > 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

    Email

    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.