Posts tagged Hosting cheap european sharepoint server 2010 hosting

SharePoint 2013 Hosting – HostForLIFE :: How To Use PnP React Accordion Control In SPFx?

Feb 18th

Posted by Peter in European SharePoint 2013 Hosting

Accordion menus and widgets are widely used on websites to manage a large amount of content and navigation lists. In this article, we will see step by step implementation of the accordion with SharePoint list.

Scenario

In this example, we will create a list called “Accordion” and in the list, we will create a Description field (it will be multiple lines of text -Rich text) and will use Title and Description field to expand and collapse.

We will use PnPJs to get list items and then will render them in the accordion form.

At the end, our output will be like this,

Let’s see the step-by-step implementation.

Implementation

Create a list with Title and Description fields as mentioned above.
Open a command prompt
Move to the path where you want to create a project
Create a project directory using:

md directory-name

1	md directory-name

Move to the above-created directory using:

cd directory-name

1	cd directory-name

Now execute the below command to create an SPFx solution:

yo @microsoft/sharepoint

1	yo @microsoft/sharepoint

It will ask some questions, as shown below,

After a successful installation, we can open a project in any source code tool. Here, I am using the VS code, so I will execute the command:

code .

code .

Now we will install pnpjs and pnp-spfx-controls-react as shown below:

npm install @pnp/sp --save    
npm install @pnp/spfx-controls-react --save --save-exact

1 2	npm install @pnp/sp --save npm install @pnp/spfx-controls-react --save --save-exact

Now go to the src > webparts > webpart > components > I{webpartname}Props.ts file,

import { WebPartContext } from "@microsoft/sp-webpart-base";  
  
export interface IPnpReactAccordionProps {  
  description: string;  
  listName: string;  
  context: WebPartContext;  
}

import { WebPartContext } from "@microsoft/sp-webpart-base";

export interface IPnpReactAccordionProps {

description: string;

listName: string;

context: WebPartContext;

}

Create a file I{webpartname}State.ts inside src > webparts > webpart > components and create state interface as below,

interface IListItem {  
    Id?: string;  
    Title: string;  
    Description: string  
}  
  
export interface IPnpReactAccordionState {  
    listItems: IListItem[];  
    errorMessage: string;  
}

interface IListItem {

Id?: string;

Title: string;

Description: string

}

export interface IPnpReactAccordionState {

listItems: IListItem[];

errorMessage: string;

}

Create a Service folder inside src and then in this folder create a file called SPService.ts. And in this file, we will create a service to get list items as below,

Here list name will come from the webpart property pane.

import { WebPartContext } from "@microsoft/sp-webpart-base";  
import { sp } from '@pnp/sp/presets/all';  
  
export class SPService {  
    constructor(private context: WebPartContext) {  
        sp.setup({  
            spfxContext: this.context  
        });  
    }  
  
    public async getListItems(listName: string) {  
        try {  
            let listItems: any[] = await sp.web.lists.getByTitle(listName)  
                .items  
                .select("Id,Title,Description")  
                .get();  
            return listItems;  
        } catch (err) {  
            Promise.reject(err);  
        }  
    }  
}

import { WebPartContext } from "@microsoft/sp-webpart-base";

import { sp } from '@pnp/sp/presets/all';

export class SPService {

constructor(private context: WebPartContext) {

sp.setup({

spfxContext: this.context

});

}

public async getListItems(listName: string) {

try {

let listItems: any[] = await sp.web.lists.getByTitle(listName)

.items

.select("Id,Title,Description")

.get();

return listItems;

} catch (err) {

Promise.reject(err);

}

Now move to the {webpartname}Webpart.ts. And create a list name property in property pane configuration and pass context and list name property as below,

import * as React from 'react';  
import * as ReactDom from 'react-dom';  
import { Version } from '@microsoft/sp-core-library';  
import {  
  IPropertyPaneConfiguration,  
  PropertyPaneTextField  
} from '@microsoft/sp-property-pane';  
import { BaseClientSideWebPart } from '@microsoft/sp-webpart-base';  
  
import * as strings from 'PnpReactAccordionWebPartStrings';  
import PnpReactAccordion from './components/PnpReactAccordion';  
import { IPnpReactAccordionProps } from './components/IPnpReactAccordionProps';  
  
export interface IPnpReactAccordionWebPartProps {  
  description: string;  
  listName: string;  
}  
  
export default class PnpReactAccordionWebPart extends BaseClientSideWebPart<IPnpReactAccordionWebPartProps> {  
  
  public render(): void {  
    const element: React.ReactElement<IPnpReactAccordionProps> = React.createElement(  
      PnpReactAccordion,  
      {  
        description: this.properties.description,  
        listName: this.properties.listName,  
        context: this.context  
      }  
    );  
  
    ReactDom.render(element, this.domElement);  
  }  
  
  protected onDispose(): void {  
    ReactDom.unmountComponentAtNode(this.domElement);  
  }  
  
  protected get dataVersion(): Version {  
    return Version.parse('1.0');  
  }  
  
  protected getPropertyPaneConfiguration(): IPropertyPaneConfiguration {  
    return {  
      pages: [  
        {  
          header: {  
            description: strings.PropertyPaneDescription  
          },  
          groups: [  
            {  
              groupName: strings.BasicGroupName,  
              groupFields: [  
                PropertyPaneTextField('description', {  
                  label: strings.DescriptionFieldLabel  
                }),  
                PropertyPaneTextField('listName', {  
                  label: strings.ListNameFieldLabel  
                })  
              ]  
            }  
          ]  
        }  
      ]  
    };  
  }  
}

import * as React from 'react';

import * as ReactDom from 'react-dom';

import { Version } from '@microsoft/sp-core-library';

import {

IPropertyPaneConfiguration,

PropertyPaneTextField

} from '@microsoft/sp-property-pane';

import { BaseClientSideWebPart } from '@microsoft/sp-webpart-base';

import * as strings from 'PnpReactAccordionWebPartStrings';

import PnpReactAccordion from './components/PnpReactAccordion';

import { IPnpReactAccordionProps } from './components/IPnpReactAccordionProps';

export interface IPnpReactAccordionWebPartProps {

description: string;

listName: string;

}

export default class PnpReactAccordionWebPart extends BaseClientSideWebPart<IPnpReactAccordionWebPartProps> {

public render(): void {

const element: React.ReactElement<IPnpReactAccordionProps> = React.createElement(

PnpReactAccordion,

{

description: this.properties.description,

listName: this.properties.listName,

context: this.context

}

);

ReactDom.render(element, this.domElement);

}

protected onDispose(): void {

ReactDom.unmountComponentAtNode(this.domElement);

}

protected get dataVersion(): Version {

return Version.parse('1.0');

}

protected getPropertyPaneConfiguration(): IPropertyPaneConfiguration {

return {

pages: [

{

header: {

description: strings.PropertyPaneDescription

groups: [

{

groupName: strings.BasicGroupName,

groupFields: [

PropertyPaneTextField('description', {

label: strings.DescriptionFieldLabel

}),

PropertyPaneTextField('listName', {

label: strings.ListNameFieldLabel

})

]

}

]

}

]

};

}

Move to the {webpartname}.tsx file and then bind the service using current context and the call service for get list items and set values in the state and render it in accordion control as below,

import * as React from 'react';  
import styles from './PnpReactAccordion.module.scss';  
import { IPnpReactAccordionProps } from './IPnpReactAccordionProps';  
import { IPnpReactAccordionState } from './IPnpReactAccordionState';  
import { escape } from '@microsoft/sp-lodash-subset';  
import { SPService } from '../../../Service/SPService';  
import { Accordion } from "@pnp/spfx-controls-react/lib/Accordion";  
  
export default class PnpReactAccordion extends React.Component<IPnpReactAccordionProps, IPnpReactAccordionState> {  
  
  private _services: SPService = null;  
  constructor(props: IPnpReactAccordionProps) {  
    super(props);  
    this.state = {  
      listItems: [],  
      errorMessage: ''  
    }  
    /** Bind service using current context */  
    this._services = new SPService(this.props.context);  
  }  
  
  public componentDidMount() {  
    this.getListItems();  
  }  
  
  /** Get items of selected list and set values in state */  
  private async getListItems() {  
    if (this.props.listName) {  
      let items = await this._services.getListItems(this.props.listName);  
      this.setState({ listItems: items });  
    }  
    else {  
      this.setState({ errorMessage: 'Please enter the list name in property pane configuration.' });  
    }  
  }  
  
  public render(): React.ReactElement<IPnpReactAccordionProps> {  
    return (  
      <div className={styles.pnpReactAccordion}>  
        {  
          //Map list items and render in accordion  
          (this.state.listItems && this.state.listItems.length) ? this.state.listItems.map((item, index) => (  
            <Accordion title={item.Title} defaultCollapsed={true} className={"itemCell"} key={index}>  
              <div className={"itemContent"}>  
                <div className={"itemResponse"} dangerouslySetInnerHTML={{ __html: item.Description }}></div>  
              </div>  
            </Accordion>  
          )) : <p>{this.state.errorMessage}</p>  
        }  
      </div>  
    );  
  }  
}

import * as React from 'react';

import styles from './PnpReactAccordion.module.scss';

import { IPnpReactAccordionProps } from './IPnpReactAccordionProps';

import { IPnpReactAccordionState } from './IPnpReactAccordionState';

import { escape } from '@microsoft/sp-lodash-subset';

import { SPService } from '../../../Service/SPService';

import { Accordion } from "@pnp/spfx-controls-react/lib/Accordion";

export default class PnpReactAccordion extends React.Component<IPnpReactAccordionProps, IPnpReactAccordionState> {

private _services: SPService = null;

constructor(props: IPnpReactAccordionProps) {

super(props);

this.state = {

listItems: [],

errorMessage: ''

}

/** Bind service using current context */

this._services = new SPService(this.props.context);

}

public componentDidMount() {

this.getListItems();

}

/** Get items of selected list and set values in state */

private async getListItems() {

if (this.props.listName) {

let items = await this._services.getListItems(this.props.listName);

this.setState({ listItems: items });

}

else {

this.setState({ errorMessage: 'Please enter the list name in property pane configuration.' });

}

public render(): React.ReactElement<IPnpReactAccordionProps> {

return (

{

//Map list items and render in accordion

(this.state.listItems && this.state.listItems.length) ? this.state.listItems.map((item, index) => (

</div>

</Accordion>

)) : <p>{this.state.errorMessage}</p>

}

</div>

);

}

Now serve the application using the below command,

gulp serve

1	gulp serve

Now test the webpart in SharePoint-SiteURL + /_layouts/15/workbench.aspx.

Output

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Feb 11th

Posted by Peter in European SharePoint 2013 Hosting

Overview

With an Office 365 subscription, we get storage space for SharePoint Online based on a number of licenses. As we create SharePoint online sites and start using them by adding our content, we start to consume the assigned storage space. It is important for us to keep a track of consumed and available site storage.

In this article, we will explore the site storage experience in modern SharePoint and its configuration.

Site Storage in SharePoint Online

The modern SharePoint online admin center gives an easy option to create new site collections.

Just a few simple fields to fill in and the site will be ready in a few seconds! But did you notice? We do not have a field to specify the storage quota for our site!

The Active sites page in the SharePoint Online admin center though, shows the storage used for each site. Also, we can see the total storage used and available for use.

Let us see from where site storage can be configured.

Site storage configuration

In the SharePoint admin center, from the left menu click Settings > Site storage limits.

The default storage limit is Automatic. The storage limit can be configured as,

Automatic
The default. All sites get the storage from a central pool. The global or SharePoint administrator does not have to manage the storage per site. It is handled automatically by SharePoint for them.
Manual
The global or SharePoint administrator can have a fined tuned site storage allocated for each of the SharePoint site collection.

Manage site storage for individual sites

If you want to manage the site storage per site, you will have to go with the manual configuration option.

With the manual option, the administrator can configure the maximum storage per site and can also set the notification for site owners when a certain percentage of the site storage limit is consumed.

The site owners or collection administrators can check the storage quota by following the below steps,

Navigate to the site settings page.
Under Site Collection Administration, click Storage Metrics.

Note

The recycle bin counts towards the site quota.

PowerShell support

The site quota can be set with PowerShell,

Set-SPOSite -Identity https://contoso.sharepoint.com -StorageQuota 1500 -StorageQuotaWarningLevel 1400

Summary

With an Office 365 subscription, we get storage space for SharePoint Online based on a number of licenses. It is important for us to keep track of consumed and available site storage. We explored the site storage experience in modern SharePoint and its configuration.

SharePoint 2013 Hosting – HostForLIFE.eu :: Send Email Using PowerShell

Jul 5th

Posted by Peter in European SharePoint 2013 Hosting

Windows PowerShell cmdlets have the capability of sending emails. We can craft an email and its various components, such as recipients, email body, email attachments, etc. using PS code. This feature removes manual effort and human intervention of composing and sending emails. This opens various avenues to make your programs more dynamic as well as appealing business-wise.

Use Cases

A few use cases where this capability is instrumental are,

Send email to target audience at the end of a script, with the result files as attachments
Send email as a part of monitoring scripts. For instance, a PS script sending out mailers when a SharePoint subsite exceeds a size limit set by administrator
Send email to administrator when a .NET site is not used frequently, based on site visits thresholds set by administrators

The Script

$runDateTime = Get-Date    $smtp = "mailservice.redduck.com"    $to = "customer1@redduck.com"     $cc = "customer2@redduck.com"       $from = "guardbot@redduck.com"        $subject = "Script Run Completed - $runDateTime"    $attachmentLocation = "C:\Users\Jarvis\Desktop\TestFile.txt"         $body = "Hello Team, <br><br>"         $body += "The program <b>Fantastic Powershell Program</b> has been completed successfully at <i>$runDateTime.</i><br><br>"    $body += "Have a great day!<br><br>"    $body += "Thank you"    Send-MailMessage -SmtpServer $smtp -To $to -Cc $cc -From $from -Subject $subject -Body $body -BodyAsHtml -Attachments $attachmentLocation    Write-Host "====== Email sent! ======"

$runDateTime = Get-Date $smtp = "mailservice.redduck.com" $to = "customer1@redduck.com" $cc = "customer2@redduck.com" $from = "guardbot@redduck.com" $subject = "Script Run Completed - $runDateTime" $attachmentLocation = "C:\Users\Jarvis\Desktop\TestFile.txt" $body = "Hello Team, <br><br>" $body += "The program <b>Fantastic Powershell Program</b> has been completed successfully at <i>$runDateTime.</i><br><br>" $body += "Have a great day!<br><br>" $body += "Thank you" Send-MailMessage -SmtpServer $smtp -To $to -Cc $cc -From $from -Subject $subject -Body $body -BodyAsHtml -Attachments $attachmentLocation Write-Host "====== Email sent! ======"

Explanation

The primary cmdlet responsible for sending the email is Send-MailMessage. It accepts various parameters. Below is a description of the parameters that are primarily used.

Parameters	Type	Description/Remarks
-To	String	The recipient of the email. For multiple recipients separate them as individual strings. For example – “user1@demo.com”, “user2@demo.com”
-From	String	The sender of the email
-Cc	String	The recipient who will be copied in the email
-Bcc	String	The recipient who will be copied but not listed in the email
-Subject	String	The subject line of the email body
-Body	String	The email body of the message.Multiple lines including variables can also be appended. HTML elements and stylings (bold, italics, etc.) can also be included as shown in the script above.
-Attachments	String	The path of the attachment fileIt is worth noting that, for attachments that exceed the limits set by the email service provider, it might fail. Hence, it is recommended to exercise caution for before attaching files in emails. For larger attachments, shared locations can be used.
-SmtpServer	String	The SMPT server that is responsible for establishing communication. This is very vital.
-BodyAsHtml	String	This parameter specifies that the email body contains HTML and will be rendered as per HTML standards.

Illustration

Modify the parameters and variables as per your requirements, execute the program, and that’s it!

The email will be delivered to your recipients!

SharePoint 2013 Hosting – HostForLIFE.eu :: Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM

Jun 27th

Posted by Peter in European SharePoint 2013 Hosting

In this article, I am sharing code snippets to create List items and update items with Taxonomy or Managed Metadata field on a custom list. I have seen some threads on how to update the multi-value taxonomy fields also. The below code demonstrates both single/multi-valued, taxonomy column update snippets via JSOM.

Create List Item

function CreateItem(isSingleValue){       SP.SOD.executeOrDelayUntilScriptLoaded(function () {             'use strict';              var context = new SP.ClientContext(_spPageContextInfo.siteAbsoluteUrl);              var list = context.get_web().get_lists().getByTitle('CustomList');                          var itemCreateInfo = new SP.ListItemCreationInformation();              var item = list.addItem(itemCreateInfo);              var field = list.get_fields().getByInternalNameOrTitle("MyMMDField");              var taxField = context.castTo(field, SP.Taxonomy.TaxonomyField);                            if(isSingleValue == true){ // this you have to handle manually , use                   var termValue = new SP.Taxonomy.TaxonomyFieldValue();                  termValue.set_label("MyWikiTerm");                  termValue.set_termGuid("fb58bc5e-5ce5-41fc-9a90-7431018aa935");                  termValue.set_wssId(-1);                  taxField.setFieldValueByValue(item, termValue);                  item.set_item("Title", "Created New Item and Set single valued Taxonomy");              }              else { // this you have to handle manually                  item.set_item("Title", "Created New Item and Multi valued Taxonomy");                  var pairs = "-1;#MyWikiTerm|fb58bc5e-5ce5-41fc-9a90-7431018aa935;#-1;#MyWikiTerm2|1cee8427-41f1-4a2b-aff3-26c67685988e";                  var termValueCollection = new SP.Taxonomy.TaxonomyFieldValueCollection(context,pairs,taxField);                  taxField.setFieldValueByValueCollection(item, termValueCollection);              }                         item.update();              context.load(item);              context.executeQueryAsync(                  function () {                      console.log('Item created sucessfully: ' + item.get_id());                  },                   function (sender, args) {                    console.log("exception in addItem");                  });          }, 'SP.Taxonomy.js');  }

Let us quickly test this via Chrome Developer Console.

Go to page and view site in the Classic experience.

Press F12. Go to Developer Console and paste the above code in the console.

Press Enter.

We should get an undefined logged-in console. Don’t worry. Ignore this message.

Now let us try this out, call this function in chrome console developer like below

If you get the above message, an item will be created in the list and the Taxonomy field would have been set. Please refer to the below screenshot for reference.

The same way, you can try multi-value also by passing the parameter as false in the CreateItem method.

Update Item

function UpdateItem(ItemId,isSingleValue){       SP.SOD.executeOrDelayUntilScriptLoaded(function () {             'use strict';              var context = new SP.ClientContext(_spPageContextInfo.siteAbsoluteUrl);              var list = context.get_web().get_lists().getByTitle('CustomList');                          var item = list.getItemById(ItemId);              var field = list.get_fields().getByInternalNameOrTitle("MyMMDField");              var taxField = context.castTo(field, SP.Taxonomy.TaxonomyField);                            if(isSingleValue == true){ // this you have to handle manually , use                   var termValue = new SP.Taxonomy.TaxonomyFieldValue();                  termValue.set_label("MyWikiTerm");                  termValue.set_termGuid("fb58bc5e-5ce5-41fc-9a90-7431018aa935");                  termValue.set_wssId(-1);                  taxField.setFieldValueByValue(item, termValue);                  item.set_item("Title", "Updated item and Set single valued Taxonomy");              }              else { // this you have to handle manually                  item.set_item("Title", "Updated Item and Multi valued Taxonomy");                  var pairs = "-1;#MyWikiTerm|fb58bc5e-5ce5-41fc-9a90-7431018aa935;#-1;#MyWikiTerm2|1cee8427-41f1-4a2b-aff3-26c67685988e";                  var termValueCollection = new SP.Taxonomy.TaxonomyFieldValueCollection(context,pairs,taxField);                  taxField.setFieldValueByValueCollection(item, termValueCollection);              }                         item.update();              context.load(item);              context.executeQueryAsync(                  function () {                      console.log('Item updated sucessfully: ' + item.get_id());                  },                   function (sender, args) {                    console.log("exception in updating item");                  });          }, 'SP.Taxonomy.js');  }

Use the same Chrome Developer Console technique to quickly test this function. Type ”UpdateItem(8,false)”. Please note that we are updating the same item created using CreateItem method.

Calling update method

Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM

Output

Remote PowerShell Execution For SharePoint On-Premises

Jun 20th

Posted by Peter in European SharePoint 2013 Hosting

We all know PowerShell is mostly used by SharePoint admins to manage their servers in a farm. SharePoint admins perform many activities as part of the SharePoint administration. In this article, we will learn how to execute remote PowerShell commands from one server on a remote server.

Why do we need this remote execution of PowerShell script?

Managing multiple servers and running a command on every server individually is time-consuming.
Centralized server (one server) to run a script on all remote servers gives more control over process.
Prevents uneccessary access to all servers.
Tighter and secure environment.
Single script to run on one machine and updating multiple servers at once.

Use case

For the sake of the article, we will take an example on how to deploy WSP from client to SharePoint Server A.

Setup Remote Server

Check if WINRM service is started and running. Go to services.msc and see if Windows Remote Management (WS-Management) service is running.

Enable PowerShell Remoting. Run the below command in PowerShell (as administrator).

Enable-PSRemoting

1	Enable-PSRemoting

Enable Server as Remote server. Run the below command in PowerShell (as administrator).

Enable-WSmanCredSSP -Role Server

1	Enable-WSmanCredSSP -Role Server

Run the below 2 commands one after another.

winrm set winrm/config/winrs ‘@{MaxShellsPerUser=”25″}’  winrm set winrm/config/winrs ‘@{MaxMemoryPerShellMB=”600″}’

1	winrm set winrm/config/winrs ‘@{MaxShellsPerUser=”25″}’ winrm set winrm/config/winrs ‘@{MaxMemoryPerShellMB=”600″}’

Notes

Firewall rule must be enabled to allow communication with the server.
Ensure the user has permission to SharePoint content database.

Setup Up Client machine

Enable PowerShell Remoting. Run the below command in PowerShell (as administrator).

Enable-PSRemoting

1	Enable-PSRemoting

Enable Client. Run the below command in PowerShell (as administrator).

Enable-WSmanCredSSP -Role "Client" -DelegateComputer "server2.contoso.com" -Force

1	Enable-WSmanCredSSP -Role "Client" -DelegateComputer "server2.contoso.com" -Force

We have configured the client to run remote commands on any remote server.

Run commands from the client machine.

Get user credentials and store in variables.

$password = ConvertTo-SecureString "your password" -AsPlainText -Force  $cred = New-Object System.Management.Automation.PSCredential("username",$password)

1	$password = ConvertTo-SecureString "your password" -AsPlainText -Force $cred = New-Object System.Management.Automation.PSCredential("username",$password)

Enable SSP and Get Session object to enter to remote server.

$s=new-PSsession -ComputerName serverA -authentication credssp -credential $cred

1	$s=new-PSsession -ComputerName serverA -authentication credssp -credential $cred

Run command via -ScriptBlock attributes. Using script block, you can run multiple commands at once on a remote server.

Invoke-Command -Session $s -ScriptBlock {Add-PSSnapin Microsoft.SharePoint.PowerShell;Update-SPSolution -Identity yourfile.wsp -LiteralPath "C:\Program Files (x86)\(location of your file)...\yourfile.wsp" -GacDeployment}

1	Invoke-Command -Session $s -ScriptBlock {Add-PSSnapin Microsoft.SharePoint.PowerShell;Update-SPSolution -Identity yourfile.wsp -LiteralPath "C:\Program Files (x86)\(location of your file)...\yourfile.wsp" -GacDeployment}

Now, enter the session of the remote server.

Enter-PSSession -session $s

1	Enter-PSSession -session $s

On successfully running this, it will run all the invoke commands on the remote server. Go to the server and check if WSP is updated.

Using the Invoke-Command method, you can run any command available and it will execute in the remote server.

Examples of other commands.

Invoke-Command -Session $s -ScriptBlock {get-SPContentDatabase}  Invoke-Command -Session $s -ScriptBlock {get-spserviceinstance}

1	Invoke-Command -Session $s -ScriptBlock {get-SPContentDatabase} Invoke-Command -Session $s -ScriptBlock {get-spserviceinstance}

Summary

In this article, we have learned how to enable remote execution of PowerShell script on SharePoint server and in an example, deployed WSP rom the client to a SharePoint Server.

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint Column Formatting: Display A Single line Of Text As Hyperlink

Jun 13th

Posted by Peter in European SharePoint 2013 Hosting

In this article, we will see how we can make a single line of text column’s values be displayed as a hyperlink with icon and how to create a dynamic href. Suppose you have an email field in your list which is a single line of text. Single line of text values will be displayed as normal text in SharePoint modern views.

Scenario

Suppose you have custom list name ‘Xyz’ and it has one column named ‘Email’ which is a single line of text (due to business requirements you have not chosen to use people and group or you are storing some external user’s email id in this column). Now when you see this in Default list view it would be displayed like below.

Now you need to make this Email column values clickable so that on click it opens an email client new mail window with ‘To’ field pre-populated. We will have to just customize this field to display it as anchor tag with href set to mailto:’brucewayne@gmail.com’.

We have 2 options to achieve this:

Using SPFx extension Field customizer
Using Column Formatting option

The first one would need you to create a package and write custom code, so here we will use the second option using the Column formatting option.

Microsoft has introduced column and view formatting to let us control how default list views are displayed. We won’t be able to change the value of fields but we will be able to change its formatting. Now let us see how can we achieve this.

Go to List Settings -> Edit Column ‘Email’ – Find option Column formatting,

Add the below Json inside text area.

    {  
        "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",  
        "elmType": "div",  
        "children": [  
            {  
                "elmType": "a",  
                "style": {  
                    "padding-right": "8px"  
                },  
                "txtContent": "@currentField",  
            "attributes": {  
            "target": "_blank",  
            "href": {  
                        "operator": "+",  
                        "operands": [  
                            "mailto:",  
                            "@currentField",  
                            "?subject=Wonder women here&body=Hey ",   
                "[$Title]",  
                            "\nJust checking, if you have saved the world?.\r\n---\r\n",  
                            "\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=",  
                            "[$ID]"  
                        ]  
                    }  
                      
                }  
            },  
            {  
                "elmType": "a",  
                "attributes": {  
            "target":"_blank",  
                    "iconName": "Mail",  
                    "class": "sp-field-quickActions",  
            "href": {  
                        "operator": "+",  
                        "operands": [  
                            "mailto:",  
                            "@currentField",  
                            "?subject=Wonder women here&body=Hey ",   
                "[$Title]",  
                            "\nJust checking, if you have saved the world?\r\n---\r\n",  
                            "\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=",  
                            "[$ID]"  
                        ]  
                    }  
                      
                }  
            }  
        ]  
    }

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",

"elmType": "div",

"children": [

{

"elmType": "a",

"style": {

"padding-right": "8px"

"txtContent": "@currentField",

"attributes": {

"target": "_blank",

"href": {

"operator": "+",

"operands": [

"mailto:",

"@currentField",

"?subject=Wonder women here&body=Hey ",

"[$Title]",

"\nJust checking, if you have saved the world?.\r\n---\r\n",

"\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=",

"[$ID]"

]

}

{

"elmType": "a",

"attributes": {

"target":"_blank",

"iconName": "Mail",

"class": "sp-field-quickActions",

"href": {

"operator": "+",

"operands": [

"mailto:",

"@currentField",

"?subject=Wonder women here&body=Hey ",

"[$Title]",

"\nJust checking, if you have saved the world?\r\n---\r\n",

"\r\nClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=",

"[$ID]"

]

}

]

}

Click Ok and go back to view and refresh the page, you should see the below.

On click of link it will open a new mail window (based on your default client configuration) with To, Subject and body field populated.

Below is what we get in anchor tag for the first item

mailto:brucewayne@gmail.com?subject=Wonder women here&body=Hey Batman%0D%0AJust checking, if you have saved the world?.%0D%0A—%0D%0A%0D%0AClick this link for more info. http://contoso.sharepoint.com/sites/ConferencePrep/Tasks/Prep/DispForm.aspx?ID=1

If you look closely the Json we have used hass some placeholders to place dynamic values of list item.

brucewayne@gmail.com – comes from @currentField

Batman – comes from [$Title]

1 – comes from [$ID]

In a similar way we can use any column values using the format [$<ColumnName>]

If we know how to format this Json, we can do wonders…there are some great examples on microsoft docs.

I will try to explain some basic structure based on our example for understanding.

The first – “elmType”: “div” – Here we are saying that we need the element to be rendered as div
Now within this div, we will create 2 children of type anchor tag (one for email and one for icon) – yes, this could have been done in a single anchor tag but I wanted to understand how it works so I kept 2 childrens both childrens “elmType”: “a” is anchor(a is html tag)
For the first one we are having attribute “txtContent”: “@currentField” – This tells it to render text inside anchor tag as value of current field.
Then we have ‘attributes’ – it is Json because we are setting different attributes like target and href.
Within href we are using again using json object as we need to concate some values, hence ‘operator’ is ‘+’ and operands are array of values with static text and dynamic values(from other columns in list item).
Values within array are separated by comma, a typical javascript array.
As explained before some of fields like $Title, $ID are being used to create href link.
href could have been built by simply using ‘+’ operator like below,

“href”: “=’http://finance.yahoo.com/quote/’ + @currentField”

Summary – This article will give you a basic start on using the column formatting feature. This can be really helpful to style columns values without any customizatoin and it will work for all the OOTB views. If you are really into what operators, expressions and elm and other attributes are supported, refer to the Json schema.

Posts tagged Hosting cheap european sharepoint server 2010 hosting

SharePoint 2013 Hosting – HostForLIFE :: How To Use PnP React Accordion Control In SPFx?

Implementation

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Overview

Site Storage in SharePoint Online

Site storage configuration

Manage site storage for individual sites

PowerShell support

Summary

SharePoint 2013 Hosting – HostForLIFE.eu :: Send Email Using PowerShell

Use Cases

The Script

Explanation

Illustration

SharePoint 2013 Hosting – HostForLIFE.eu :: Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM

Remote PowerShell Execution For SharePoint On-Premises

Why do we need this remote execution of PowerShell script?

Use case

Setup Remote Server

Setup Up Client machine

Summary

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint Column Formatting: Display A Single line Of Text As Hyperlink

BLOGROLL

Featured On

Posts tagged Hosting cheap european sharepoint server 2010 hosting

SharePoint 2013 Hosting – HostForLIFE :: How To Use PnP React Accordion Control In SPFx?

Implementation

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Overview

Site Storage in SharePoint Online

Site storage configuration

Manage site storage for individual sites

PowerShell support

Summary

SharePoint 2013 Hosting – HostForLIFE.eu :: Send Email Using PowerShell

Use Cases

The Script

Explanation

Illustration

SharePoint 2013 Hosting – HostForLIFE.eu :: Update Taxonomy Or Managed Metadata Field Via SharePoint JSOM

Remote PowerShell Execution For SharePoint On-Premises

Why do we need this remote execution of PowerShell script?

Use case

Setup Remote Server

Setup Up Client machine

Summary

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint Column Formatting: Display A Single line Of Text As Hyperlink

BLOGROLL

Featured On

Tags