By -

 Concat(

    GroupBy(

        'CollectionName',

        "IdentityColumn",

        "GroupedData",

        "NameColumn"

    ),

    If(

        CountRows("GroupedData") = 1,

        "GroupedData[@NameColumn]",

        Concatenate(

            "GroupedData[@NameColumn]",

            ", ",

            "GroupedData[@NameColumn]",

            GroupedData,

            ", "

        )

    ),

    " "

)

Anandan is a SharePoint and Microsoft Azure consultant.He is having 9+ years of experience in the web, cloud, Machine Learning, IoT and mobile technology. He handled multi-platform solution as a consultant with the experience of designing, developing and deploying solutions by leveraging Microsoft, IBM, Apple, and Google technology stack, has played a dynamic role in the development of SharePoint and ML technologies. He writes articles related to SharePoint Online/On-Premises and Machine Learning.

Comments

Post a Comment

Popular posts from this blog

Sharepoint 2013 Script Editor web part CData for custom page layout using visual studio.

By -
In order to include a javascript into a custom page layout,we can use script editor web part. Below snippet used to add a Script Editor web part to a layout.This script editor web part specific for Sharepoint 2013.But in the case of a Sharepoint 2010, we don't have a script editor web part.So we can use content editor web part in order to include a javascript to a page or layout. <AllUsersWebPart WebPartZoneID="MainTopZone" WebPartOrder="1">         <![CDATA[       <webParts> <webPart xmlns="http://schemas.microsoft.com/WebPart/v3"> <metaData> <type name= "Microsoft.SharePoint.WebPartPages.ScriptEditorWebPart, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <importErrorMessage>$Resources:core,ImportErrorMessage;</importErrorMessage> </metaData> <data> <properties> <property name="Title" ty...
Read more

List attachment link in SharePoint 2013 search.

By -
Issue : List attachments links are not able to show in SharePoint 2013 search. Causes: There is no clear field for the attachments in SharePoint list.So we could not get the property related to attachments in the crawl. Solution:We can manually add the field in list where we have the attachment.This field will have the attachment URL.We can make this by Item added event receiver.Now our custom field will be available in crawl property and we can able to create a new managed property, which will map the custom field crawl property. So we can edit the display template based on new managed property.Display template sample is available in the below snippet. Crawl of the list attachment arguments are given in the below URLs. http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=83 http://sajiviswam.wordpress.com/2011/11/23/are-list-attachments-indexed-in-sharepoint-search/ <html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F...
Read more

Bulk update and delete using SPservice in SharePoint

By -
$().SPServices.SPUpdateMultipleListItems({ listName: "States" , CAMLQuery: "<Query><Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Active</Value></Eq></Where></Query>" , valuepairs: [["Status", "Inactive"]] }); This call to SPUpdateMultipleListItems will update all of the items in the States list which have their Status = "Active", setting their Status = "Inactive". $().SPServices.SPUpdateMultipleListItems({ listName: "States" , CAMLQuery: "<Query><Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Inactive</Value></Eq></Where></Query>" , batchCmd: "Delete" }); This call to SPUpdateMultipleListItems will delete all of the items in the States list which have their Status = "Inactive".
Read more