InfoPath URL Formula Functions

Introduction

InfoPath has number of inbuilt functions, which can be used for conditional formatting, setting the value to the fields or embedded as an argument to the other functions.

From the various group of functions, we will see here the details of URL functional group.

The URL functional group has the below mentioned items that can be used in formula,

URL Function

Formula

Description

SharePointListUrl

SharePointListUrl()

Returns the SharePoint List URL where the form is implemented

SharePointServerRootUrl

SharePointServerRootUrl()

Returns the SharePoint Server / web application URL where the form is hosted

SharePointSiteCollectionUrl

SharePointSiteCollectionUrl()

Returns the SharePoint Site Collection URL where the form is hosted

SharePointSiteUrl

SharePointSiteUrl()

Returns the SharePoint sub site URL where the form is hosted

For example,

I have a List Form, which is customized with InfoPath under the following list,

http://sharepointsite/sites/infopathsitecollection/subsite/lists/testlist

We will get the corresponding values for each url functions as shown in below table.

URL Function

Value

SharePointListUrl

http://sharepointsite/sites/infopathsitecollection/subsite/lists/testlist/

SharePointServerRootUrl

http://sharepointsite/

SharePointSiteCollectionUrl

http://sharepointsite/sites/infopathsitecollection/

SharePointSiteUrl

http://sharepointsite/sites/infopathsitecollection/subsite/