Skip to main content
BOOK A DEMO

Value formats of all column types

skybow Support
  • Article Updated

This article documents the returned values when using field placeholders:
GET - returned values by placeholders
And describes the expected format to set values by Assignment Expression:
SET - expected format to set values

 

SET - expected format to set values

Type Value type Assignment Expression (SET) Result/Notes
Modern Forms Page, Form & List Actions Scheduled & Triggered Actions
Single line of text string ="Test" Test
Multiple lines of text - Plain text string ="This is \na test"

This is

a test
Multiple lines of text - Rich text

string

(limited HTML)

 ="This is <br>a <b>bold</b> <i>italic</i> Test" This is a
bold italic Test
Multiple lines of text - Enhanced rich text string
(HTML)

='<div class="ExternalClass..."><div ...>Test<br>...</div>...</div>'

// Use single quotes ' around - to prevent conflict with double quotes " of HTML 

 This is a
1_favicon.png
bold italic Test
Choice - single selection string ="Test 3" Test 3
Choice - multiple selection string ="Test 15, Test 16, Test 17" Test 15, Test 16, Test 17
Number - 0 decimal places number =12 12
Number - x decimal places number =12.75

12.75

//visualized comma separator , or . depends on region/language settings
Number - percentage number =60  60%
Currency number =648 $648.00
Date and Time - Date Only date object

=new Date()
// current date & time

=new Date(2024,6,3); 
// 6/3/2024

Check out examples of how to set date time field for more information

6/3/2024

(visualized format depends on region/language settings)
Date and Time - Date & Time date object

=new Date()
// current date & time

=new Date(2024,6,3,9,30,00);
// 6/3/2024 9:30 PM

6/3/2024 9:30 PM

(visualized format depends on region/language settings)
Lookup - single selection number =326
// ID of target item 		Testitem 5
Lookup - multiple selection multi lookup value object

="34;#Testitem 3;#75;#Testitem 4;#345;#Testitem 5"
// string format: "id;#text;#id2;#text2"

=[[spLookupMulti.ID]].map(function(id){ return id + ";#value";}).join(";#")
// convert array of IDs into correct string format (here from another multi lookup value)

 Testitem 3, Testitem 4, Testitem 5
Data Lookup - single selection string ="18;#CrossSite Testitem 2"
// string format: "id;#text" 		CrossSite Testitem 2
Data Lookup - multi selection string ="15;#CrossSite Testitem 3;#19;#CrossSite Testitem 4;#20;#CrossSite Testitem 5"
// string format: "id;#text;#id2;#text2" 		CrossSite Testitem 3, CrossSite Testitem 4, CrossSite Testitem 5
Yes/No boolean

=true

=false

 visualized as "Yes" and "No"
Person or Group - People Only - single selection user object

by email*: ="user1@skybow.onmicrosoft.com" 

* User or group should be already added to the SP site (ensured) before setting

by ID:
=135

by email*: ="user1@skybow.onmicrosoft.com" 

* User or group should be already added to the SP site (ensured) before setting

by ID:
=135

by email: ="user1@skybow.onmicrosoft.com"

User1

// user display name
Person or Group - People Only - multi selection collection of user object

by email*:
=["user1@skybowdev.onmicrosoft.com", "user2@skybowdev.onmicrosoft.com"]

* User or group should be already added to the SP site (ensured) before setting

by ID:
=[9,12]

by email*:
=["user1@skybowdev.onmicrosoft.com", "user2@skybowdev.onmicrosoft.com"]

* User or group should be already added to the SP site (ensured) before setting

by ID:
=[9,12]

by email:
=["user1@skybowdev.onmicrosoft.com", "user2@skybowdev.onmicrosoft.com"]

User1, User2

// user's  display name
Person or Group - People and Groups - single selection user object

by email*:
="team@skybowdev.onmicrosoft.com"

* User or group should be already added to the SP site (ensured) before setting

 by ID:
=8

by email*:
="team@skybowdev.onmicrosoft.com"

* User or group should be already added to the SP site (ensured) before setting

by ID:
=8

by email:
="team@skybowdev.onmicrosoft.com"

Team

// group display name
Person or Group - People and Groups - multi selection collection of user/group object

by email*:
=["group1@skybowdev.onmicrosoft.com", "group2@skybowdev.onmicrosoft.com"]

* User or group should be already added to the SP site (ensured) before setting

by IDs:
=[49,51,8]

by email*:
=["group1@skybowdev.onmicrosoft.com", "group2@skybowdev.onmicrosoft.com"]

* User or group should be already added to the SP site (ensured) before setting

by Name of the SP group:
="Developer Site Members"

by IDs:
=[49,51,8]

by email:
=["group1@skybowdev.onmicrosoft.com", "group2@skybowdev.onmicrosoft.com"]

by Name of the SP group:
="Developer Site Members"

Group1, Group2

// group's display name
Hyperlink or Picture - Hyperlink object

="https://www.skybow.com, Link to skybow"

// Use , ([comma][space]) to separate URL from display text

 Link to skybow
Hyperlink or Picture - Picture object

="https://yourTenant.sharepoint.com/sites/yourSite/SiteAssets/image.png, Alternative Text"

// Use , ([comma][space]) to separate URL from alternative text

 1_favicon.png
Image object - =JSON.stringify({serverRelativeUrl: "/sites/yourSite/SiteAssets/image001.jpg", fileName: "image001.jpg"}) 1_favicon.png
Managed Metadata - single values taxonomy term object

-

="CEO|6591c573-54d7-4fe8-9f2a-bab74f1e5df1"

="CEO|6591c573-54d7-4fe8-9f2a-bab74f1e5df1"

 CEO
// term's display name
={termId: "6591c573-54d7-4fe8-9f2a-bab74f1e5df1",text: "CEO"} ={termId: "6591c573-54d7-4fe8-9f2a-bab74f1e5df1",text: "CEO"} -
Managed Metadata - multiple values collection of taxonomy terms object - = "CEO|6591c573-54d7-4fe8-9f2a-bab74f1e5df1";"COO|173c8c88-d07a-4c97-9292-0ffde5316958"  = "CEO|6591c573-54d7-4fe8-9f2a-bab74f1e5df1";"COO|173c8c88-d07a-4c97-9292-0ffde5316958"  CEO,COO
// term's display names
=[{termId: "6591c573-54d7-4fe8-9f2a-bab74f1e5df1",text: "CEO"},{termId: "173c8c88-d07a-4c97-9292-0ffde5316958", text: "COO"}] =[{termId: "6591c573-54d7-4fe8-9f2a-bab74f1e5df1",text: "CEO"},{termId: "173c8c88-d07a-4c97-9292-0ffde5316958", text: "COO"}] -


Note: Outputs from column's field placeholder works without any reformatting to set a field value of same type. E.g. copy an existing value to another item's column by field placeholder expression:
=[[YourFieldNameOfSameType]]

 

GET - returned values by placeholders

Type Field placeholder (GET) Result/Return
    Modern Forms Page, Form & List Actions Scheduled & Triggered Actions
Single line of text =[[Title]] string
Example: test
Multiple lines of text - Plain text =[[PlainText]] string
Example: test
Multiple lines of text - Rich text =[[MultiRichText]] string
Example: test
Multiple lines of text - Enhanced rich text =[[EnhancedRichText]] string
Example: <div class="ExternalClass..."><div ...>Test<br>...</div>...</div>
Choice - single selection =[[Status]] string
Example: Done
Choice - multiple selection =[[Country]] array of string
Example: ["Barcelona", "Krakow"]
Number - 0 decimal places =[[Number]] number
Example: 150
Number - x decimal places =[[NrDecimal]] number
Example: 12.12
Number - percentage =[NrPercentage]] number
Example: 85
Currency =[[Currency]] number
Example: 150
Date and Time - Date Only =[[Date]]

date object in format:

Example: Thu Apr 25 2024 12:29:00 GMT+0300 (Eastern European Summer Time).

// for the date object toString method returns date in format 6/3/2024 (visualized format depends on region/language settings)

date object 

Example: 2024-02-13T10:58:11Z
Date and Time - Date & Time =[[DateTime]]

date object in format:

Example: Thu Apr 25 2024 12:29:00 GMT+0300 (Eastern European Summer Time).

// for the date object toString method returns date in format 6/3/2024 (visualized format depends on region/language settings)

date object in format:

Example: 2024-02-13T10:58:11Z
Lookup - single selection =[[Country]]

string

Example: Poland

object

Example: [{"LookupId":7,"LookupValue":"Latvia","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"}]
Lookup - multiple selection

=[[Country]]

array of strings

Example: ["Spain", "Lithuania"]

array of objects

Example: [{"LookupId":6,"LookupValue":"Spain","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"},{"LookupId":7,"LookupValue":"Lithuania","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"},{"LookupId":3,"LookupValue":"France","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"}]
Lookup-nested values

=[[Lookup.Column]]

=[[Lookup1.Lookup2.Column]]

 

string / array of strings

Example: Zurich

Example2: ["Zurich","Bern","Geneva"]

Note: for the case of lookup multiple selection a placeholder [[Lookup.Column]] will return a string in the case of one value selection and an array of strings in the case of multiple value selection. To get the array in the case of one value selection, you can use the following expression:

var fieldValue = [];
if (null != [[Lookup.Column]]) {
   if (Array.isArray([[Lookup.Column]])) {
         fieldValue = [[Lookup.Column]];
     }
     else {
         fieldValue.push([[Lookup.Column]]);
     }
}
return fieldValue;

- (not supported)
Data Lookup - single selection =[[Datalookup]]

string

Example: Poland

object

Example: [{"LookupId":2,"LookupValue":"Item32","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"}]
Data Lookup - multi selection =[[DatalookupMulti]]

array of strings

Example: ["Warsaw","Milan","Venice"]

array of objects

Example: [{"LookupId":6,"LookupValue":"Milan","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"},{"LookupId":7,"LookupValue":"Venice","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"},{"LookupId":3,"LookupValue":"Warsaw","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"}]"
Yes/No =[[YesNo]]

boolean

Example 1: false

Example 2: true
Person or Group - People Only - single selection =[[User]]

object

Example: [{DisplayName:"User Test1", Email:"testuser@contoso.com", Key:"i:0#.f|membership|testuser@contoso.com", UserId:12}]

 
Person or Group - People Only - multi selection =[[Users]]

array of objects

Example: [{DisplayName:"User Test1", Email:"testuser1@contoso.com", Key:"i:0#.f|membership|testuser1@contoso.com", UserId:12},{DisplayName:"User Test2", Email:"testuser2@contoso.com", Key:"i:0#.f|membership|testuser2@contoso.com", UserId:13}]
Person or Group - People and Groups - single selection =[[Group]]

array of objects

Example: [{ DisplayName:"Group Members", Email:"group@dev.onmicrosoft.com", Key:"c:0o.c|federateddirectoryclaimprovider|d1b2d664-b6e4-42b8-aaa4-e14ed5ef432f", UserId:112}]
Person or Group - People and Groups - multi selection =[[Groups]]

array of objects

Example: [{ DisplayName:"User Test1", Email:"testuser1@contoso.com", Key:"i:0#.f|membership|testuser1@contoso.com", UserId:12},{DisplayName:"User Test2", Email:"testuser2@contoso.com", Key:"i:0#.f|membership|testuser2@contoso.com", UserId:12}]
Hyperlink or Picture - Hyperlink =[[Hyperlink]]

object

Example: [{Description:"skybow", URL:"https://my.skybow.com"}]

object

Example: [{"Description":"skybow", "Url":"https://my.skybow.com",}]
Hyperlink or Picture - Picture =[[Picture]]

object

Example: [{Description:"skybow", URL:"https://my.skybow.com"}]

object

Example: [{"Description":"skybow","Url":"https://my.skybow.com", "TypeId":"{fa8b44af-7b43-43f2-904a-bd319497011e}"}]
Image =[[Image]]

object

Example: [{FileName:"image0011.jpg", URL:"/sites/dev_site/SiteAssets/Lists/8438ff5c-ae8b-4701-84f4-2841b8eeb1a4/image0011.jpg"}]

object

Example: [{"ServerRelativeUrl":"/sites/dev_site/SiteAssets/Lists/8438ff5c-ae8b-4701-84f4-2841b8eeb1a4/image1.jpg",
"ServerUrl":"", "FileName":"image0011.jpg",
"Url":"/sites/dev_site/SiteAssets/Lists/8438ff5c-ae8b-4701-84f4-2841b8eeb1a4/image01.jpg",
"FileId":"2603337e-dc2b-4aae-ab13-3fc4dd64fa13"}]

// for the case if image is added using ootb functionality the column returns object {"ServerRelativeUrl":"","ServerUrl":"","FileName":"Reserved_ImageAttachment_[5]_[Image][16]_[license wildcard][1]_[2].png","Url":"","FileId":""}
Managed Metadata - single values =[[Metadata]]

object

Example: [{termId : "173c8c88-d07a-4c97-9292-0ffde5316958",
text : "COO"}]

 
Managed Metadata - multiple values =[[MetadataMulti]]

array of objects

Example: [{termId:"ab986e40-532e-4ba1-a04f-99905e9a21c2",
text:"CTO"}, {termId:"173c8c88-d07a-4c97-9292-0ffde5316958",
text:"COO"}]

 

 

Related articles