GetUniqueItems function

This article describes the formula syntax and usage of the GetUniqueItems function in JungleDocs.


Description

Returns items with a unique ID from a SharePoint list.

Syntax

GetUniqueItems(recordSet; [fieldName])

The GetUniqueItems function syntax has the following arguments:

  • RecordSet   Required. Any function that returns a set of items (e.g., GetView(), FindItems(), ReportItems()).
  • FieldName   Optional. A SharePoint column name.

Example

GetUniqueItems(GetView("Contacts"; "AllItems"):Company) 

Returns unique items by the Company lookup field values from the Contacts list's AllItems view.

GetUniqueItems(ReportItems; "FullName")

Returns unique items by the FullName field value in the current list.

GetUniqueItems(ReportItems:Company) 

Returns unique items in the lookup list through the Company lookup field.

GetUniqueItems(ReportItems:Company; "Email")

Returns unique items by the Email field values in the lookup list through the Company lookup field.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us