Table of contents

The skybow Expression Builder helps users to easily write and verify expressions, set values and parameters, set dynamic conditions/validation rules in different places in Modern Forms, List Actions, Background calculated expressions, Scheduled and Triggered actions, etc.

Expression builder has a wide variety of context placeholders and functions that allow users to get properties from the context of the list, forms, site, user profile, etc., set dynamic conditions and validation to use them to write complex, powerful expressions in your solution.

Availability

Below we will consider more about the functions available and how to use them.

Form Placeholders

Form placeholders get the properties of the form you are on. Form placeholders can used to set values in the expressions/actions (ItemID and ListID), and also evaluate some conditions, apply validation, etc. ( IsDisplayForm, IsEditForm, IsNewForm, and IsSubListForm). Form placeholders are available in the Modern Forms.

Functions

Functions allow evaluate custom expressions inside the placeholders or inside a file.  Functions also allow to extract (values) data from the list/library of the current site and also from the list/library of the other site collection. Backgrounds features like Scheduled/Triggered actions have also specific placeholders that could be used in the expressions. 

*  These functions are available only for Scheduled and Triggered Actions

• [[@Functions.EvaluateExpression('expression code')]]:

[[@Functions.EvaluateExpression([[@Web.GetFirstValueForQuery('Settings', 
'<View><Query><Where><Eq><FieldRef Name="Title"/><Value Type="Text">ApproveTaskEmailBodyTemplate</Value></Eq></Where></Query></View>',
'ExpressionCode')]])]]

• [[@Functions.GetFileContent('file path', false)]]:

[[@Functions.GetFileContent('[[@Web.Url]]/Shared%20Documents/emailTemplate.txt', true)]]

emailTemplate.txt:
Hi [[Assignedto]],
A new task was assigned to you:
Task: [[ID]]-[[Title]],
Due date: [[Duedate]],
Requested by: [[Author]],
Best Regards [[Created]].

Outputs: 

• [[@Functions.GetFirstValueForQuery('List server-relative or full Url', 'Caml query', 'FieldName')]]:

var ID = [[@Functions.GetFirstValueForQuery('/sites/dev_sc/testingsolution/Lists/Tasks', '<View Scope="Recursive"><Query><Where><Eq><FieldRef Name="Status" /><Value Type="Text" ProviderType="Value">In Progress</Value></Eq></Where></Query></View>', 'ID')]]
alert(ID);

• [[@Functions.GetValuesForQuery('List server-relative or full Url', 'Caml query', 'FieldName')]]

[[@Functions.GetValuesForQuery('Lists/Invoice', '<View Scope="Recursive"><Query><Where><Eq><FieldRef Name="Status" /><Value Type="Text" ProviderType="Value">Done</Value></Eq></Where></Query></View>', 'Title')]]

• [[@Functions.QueryList('List server-relative or full Url', 'Caml query')]]

var items = [[@Functions.QueryList('Lists/Invoice', '<View Scope="Recursive"><Query><Where><Geq><FieldRef Name="InvoceDate" /><Value IncludeTimeValue="FALSE" ProviderType="DateTimeToday"><Today OffsetDays="0" /></Value></Geq></Where></Query><ViewFields><FieldRef Name="Title" /></ViewFields></View>')]]
var str = items.map((item) => { return item["Title"] + " created by " + item["Author"].get_email(); }).join(", ")
return str;

Item Placeholders

Item context placeholders allows to get properties from the item you are working on, such as Display form URL, Edit form URL, ID and can be used in your expressions. Item placeholders are available in the Modern Forms, List Actions, Scheduled and Triggered Actions and Background Calculated Expressions.

List Placeholders

List context placeholders allows to get properties from the list you are working on, such as ID, Title, Internal name, URL, etc. and can be used in your expressions. List placeholders are available in the Modern Forms, List Actions, Scheduled and Triggered Actions and Background Calculated Expressions. 

Solution Placeholders

Solution context placeholders allows to get properties from the solution you are working on, such as solition ID and an email of the solution's owner. Solution placeholders are available only in Scheduled and Triggered Actions and Background Calculated Expressions. 

Page placeholders/functions

Placeholders retrieve the data in the context of the current page.

User placeholders

User placeholders return information about the current user such as email, ID, location, the info from the SharePoint user profile, etc. Also, user functions let to check the group membership (SharePoint group or Azure Active Directory Group) and the permission for the current user on the specific item, or on the list.

Web/Site placeholders/functions

Web/Site placeholders will return the information about the current site collections or the current web. e.g. Title, URL, Language. ServerRelativeURL and URL can bring back the server relative and the full URL of the current site collection/web. 

Also, context placeholder functions, like GetFirstValueForQuery and GetValuesForQuery, allow to retrieve  values of the fields from the specified list using CAML Queries. Read more about the query functions here.

• [[@Web.GetFirstValueForQuery('ListName or relative Url', 'Caml query', 'FieldName')]]:

var taskName = [[@Web.GetFirstValueForQuery('Task list', '<Where><Eq><FieldRef Name="Status" /><Value Type="Text" ProviderType="Value">Done</Value></Eq></Where>', 'Title')]];
alert(taskName);

• [[@Web.GetValuesForQuery('ListName or relative Url', 'Caml query', 'FieldName')]]:

[[@Web.GetFirstValueForQuery('Task list', '<Qwery><Where><Eq><FieldRef Name="Status" /><Value Type="Text" ProviderType="Value">Done</Value></Eq></Where></Query>', 'Title')]];

• [[@Web.QueryList('ListName or relative Url', 'Caml query', MaxRowNumber, 'View Fields', 'Viewattributes')]]:

var items = [[@Web.QueryList('Contacts', '<View Scope="Recursive"><Query><Where><Eq><FieldRef Name="Status" /><Value Type="Text" ProviderType="Value">Approved</Value></Eq></Where></Query><ViewFields><FieldRef Name="ID" /><FieldRef Name="Title" /><FieldRef Name="Author" /></ViewFields></View>', 10, 'ID, Title, Author', '')]];
var str = items.map((item) => { return item["Title"] + " created by " + item["Author"].get_email(); }).join(", ")
return str;