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 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 | ||
| Location | object | =({ DisplayName: "Landesmuseum", Address: { City: "Zurich", Street: "Museumstrasse 2", CountryOrRegion: "Switzerland" }, Coordinates: { Latitude: "47.3791", Longitude: "8.54054" }}) | =JSON.stringify({ DisplayName: "Landesmuseum", Address: { City: "Zurich", Street: "Museumstrasse 2", CountryOrRegion: "Switzerland" }, Coordinates: { Latitude: "47.3791", Longitude: "8.54054" }}) |
Landesmuseum
Museumstrasse 2
Zurich, Switzerland
|
|
| Date and Time - Date Only | date object |
=new Date() =new Date(2024,6,3); 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() =new Date(2024,6,3,9,30,00); |
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" =[[spLookupMulti.ID]].map(function(id){ return id + ";#value";}).join(";#") |
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: by email*: ="user1@skybow.onmicrosoft.com" * User or group should be already added to the SP site (ensured) before setting |
by ID: by email: ="user1@skybow.onmicrosoft.com" |
User1 // user display name |
| Person or Group - People Only - multi selection | collection of user object |
by email*: * User or group should be already added to the SP site (ensured) before setting |
by ID: * User or group should be already added to the SP site (ensured) before setting |
by ID: |
User1, User2 // user's display name |
| Person or Group - People and Groups - single selection | user object |
by email*: * 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: |
Team // group display name |
| Person or Group - People and Groups - multi selection | collection of user/group object |
by email*: * User or group should be already added to the SP site (ensured) before setting |
by IDs: * User or group should be already added to the SP site (ensured) before setting |
by IDs: |
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 |
|||
| Image | object | - | =JSON.stringify({serverRelativeUrl: "/sites/yourSite/SiteAssets/image001.jpg", fileName: "image001.jpg"}) | ||
| Managed Metadata - single values | taxonomy term object |
"Label|TermGuid": |
CEO // term's display name |
||
|
{termId:string, text:string}: |
- |
||||
|
{TermID:string, Label:string}: |
- |
||||
|
{TermGuid:string, Label:string}: |
- | ||||
| Managed Metadata - multiple values | collection of taxonomy terms object |
"Label1|TermGuid1;Label2|TermGuid2": |
CEO,COO // term's display names |
||
|
[{TermID:string, Label:string}]: |
- | ||||
|
[{TermGuid:string, Label:string}]: |
- | ||||
|
[{termId:string, text:string}]: =[{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 |
||
| Location | =[[Location]] |
object Example: {DisplayName: "Landesmuseum","Address":{"City":"Zurich","Street":"Museumstrasse 2","CountryOrRegion":"Switzerland"},"Coordinates":{"Latitude":47.3791,"Longitude":8.54054} |
||
| 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"] |
string / array of strings Example: Zurich Example2: ["Zurich","Bern","Geneva"] * Supported only for the lookups from the current site |
|
| 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", // 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",
|
||
| Managed Metadata - multiple values | =[[MetadataMulti]] |
array of objects Example: [{termId:"ab986e40-532e-4ba1-a04f-99905e9a21c2",
|
||