Skip to main content
Skip table of contents

SharePoint Property Value Formatting

Creating Rules is straight forward for most situations because you are usually just comparing the rule value to the item being classified’s property value. This key-value formatting is referred to as Standard Formatting.

However, some Connectors support different types of properties that may provide atypical value formats or multiple values for a single property. Handling these scenarios requires that you understand how the Connector will format Repository-specific property values for atypical property types. This type of formatting is referred to as Special Formatting.

SharePoint and SharePoint Online

Property Type

Property Value Formatting

Notes

Single line of text

Text Value

Multiple lines of text

Text Value

Choice

Choice1

Choice (Multiple)

Choice1|Choice2|Choice2

Number

7

Currency

$7.00

Date and Time

2014-02-24T23:35:50.0000000Z

UTC

Date Only

2014-02-24T00:00:00.0000000Z

UTC

Lookup

Value1

Lookup (Multiple)

Value1|Value2|Value3

Yes/No

Yes

Yes or no

Person Group

Login Name1

Person or Group (Multiple)

Login Name1|Login Name2

Hyperlink or Picture

http://url, Description

Managed Metadata

Term1|Term2|Term3

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.