Other Related Post

SharePoint Hosting – Global Navigation In Modern SharePoint Using SPFx, PnP And Fluent UI

Jul 22nd

Modern SharePoint architecture gives fantastic OOTB global navigation, and hub site navigation has amazing potential to maintain consistency throughout the portal. Then why do we need to develop custom global navigation in modern SharePoint sites?

Let us talk about the business scenario.

Nowadays, a number of organizations are migrating classic intranet portals to modern sites. Many of them have implemented custom global navigation in a classic environment with a number of links and complex tree structures.

Employees are habitual with this global navigation. So, many organizations prefer similar global navigation in Modern SharePoint sites.

Steps

Configure Terms in Term Stores
Create Solution for Application Customizer
Import Required Packages
Create React Component
Add React Component Reference to Application Customizer
Get Terms using PnP
Render Terms using Command Bar and styling
Test Solution

Step 1 – Configure Terms in Term Store.

Go to URL : https://<TenantName>-admin.sharepoint.com/_layouts/15/online/AdminHome.aspx#/termStoreAdminCenter

Create Term Group.

Copy Group GUID and Paste it into one document

Create Term Set inside created Term Group

Enable Use Term set for Site Navigation
Copy term Set Id and Paste it in one document.

Create Terms Inside create Term Sets.

Step 2 – Create SPFx Solution for Application Customizer

Open Node command Prompt.

Go to your physical location where you want to create a solution.

Once all required packages are installed then you will get the below message.

open Code in visual studio code by typing below one line code in node command prompt.

The solution structure looks like the ad below,

Step 3 – Import required packages from npm

Install PnP npm package,

Install React Fluent UI Package,

Install react and react Dom and Its Dev Dependencies.

Open package.json file which should look like as below,

package.json

Step 4 – Create React Component

Create new folder called “Components” to “..src\extensions\gobalNavigationBar”.

Create 3 files inside the components folder.

GlobalNav.tsx
IGlobalNavProps.ts
IGlobalNavState.ts

Add below code to IGlobalNavProps.ts

Add below code to IGlobalNavState.ts,

Add below code to IGlobalNav.tsx,

Step 5 – Add React Component Reference to Application Customizer

Open GobalNavigationBarApplicationCustomizer.ts file and add the below code.

GobalNavigationBarApplicationCustomizer.ts

Step 6: Get Terms using PnP

Open GlobalNav.tsx file and do the below changes.

GlobalNav.tsx

Add below references to the file.

<span class="token keyword module keyword-import">import</span> <span class="token imports"><span class="token punctuation">{</span> sp <span class="token punctuation">}</span></span> <span class="token keyword module keyword-from">from</span> <span class="token string">"@pnp/sp"</span><span class="token punctuation">;</span>
<span class="token keyword module keyword-import">import</span> <span class="token string">"@pnp/sp/taxonomy"</span><span class="token punctuation">;</span>
<span class="token keyword module keyword-import">import</span> <span class="token imports"><span class="token punctuation">{</span> dateAdd<span class="token punctuation">,</span> <span class="token maybe-class-name">PnPClientStorage</span> <span class="token punctuation">}</span></span> <span class="token keyword module keyword-from">from</span> <span class="token string">"@pnp/common"</span><span class="token punctuation">;</span>
<span class="token keyword module keyword-import">import</span> <span class="token imports"><span class="token punctuation">{</span> <span class="token maybe-class-name">IOrderedTermInfo</span> <span class="token punctuation">}</span></span> <span class="token keyword module keyword-from">from</span> <span class="token string">'@pnp/sp/taxonomy'</span><span class="token punctuation">;</span>

<span class="token keyword keyword-const">const</span> myKey<span class="token operator">:</span> string <span class="token operator">=</span> <span class="token string">"navigationElements"</span><span class="token punctuation">;</span>

import { sp } from "@pnp/sp";

import "@pnp/sp/taxonomy";

import { dateAdd, PnPClientStorage } from "@pnp/common";

import { IOrderedTermInfo } from '@pnp/sp/taxonomy';

const myKey: string = "navigationElements";

Update below code to GlobalNav.tsx.

<span class="token keyword keyword-private">private</span> store <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token class-name">PnPClientStorage</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
   <span class="token function">constructor</span><span class="token punctuation">(</span><span class="token parameter">props<span class="token operator">:</span> <span class="token maybe-class-name">IGlobalNavProps</span></span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
       <span class="token keyword keyword-super">super</span><span class="token punctuation">(</span>props<span class="token punctuation">)</span><span class="token punctuation">;</span>
       <span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token property-access">state</span> <span class="token operator">=</span> <span class="token punctuation">{</span>
           loading<span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
           terms<span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span>
       <span class="token punctuation">}</span>
   <span class="token punctuation">}</span>

private store = new PnPClientStorage();

constructor(props: IGlobalNavProps) {

super(props);

this.state = {

loading: false,

terms: []

}

Update componentdidmount() method with below code in GlobalNav.tsx.

<span class="token keyword keyword-public">public</span> <span class="token function">componentDidMount</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
        <span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token method function property-access">setState</span><span class="token punctuation">(</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token keyword keyword-async">async</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token arrow operator">=&gt;</span> <span class="token punctuation">{</span>
            <span class="token comment">// this portion is responsible for getting terms from term store</span>
            <span class="token keyword keyword-const">const</span> cachedTermInfo <span class="token operator">=</span> <span class="token keyword control-flow keyword-await">await</span> <span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token property-access">store</span><span class="token punctuation">.</span><span class="token property-access">local</span><span class="token punctuation">.</span><span class="token method function property-access">getOrPut</span><span class="token punctuation">(</span>myKey<span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token arrow operator">=&gt;</span> <span class="token punctuation">{</span>
                <span class="token keyword control-flow keyword-return">return</span> sp<span class="token punctuation">.</span><span class="token property-access">termStore</span><span class="token punctuation">.</span><span class="token property-access">groups</span><span class="token punctuation">.</span><span class="token method function property-access">getById</span><span class="token punctuation">(</span><span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token property-access">props</span><span class="token punctuation">.</span><span class="token property-access">termGroupId</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token property-access">sets</span><span class="token punctuation">.</span><span class="token method function property-access">getById</span><span class="token punctuation">(</span><span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token property-access">props</span><span class="token punctuation">.</span><span class="token property-access">termSetId</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token method function property-access">getAllChildrenAsOrderedTree</span><span class="token punctuation">(</span><span class="token punctuation">{</span> retrieveProperties<span class="token operator">:</span> <span class="token boolean">true</span> <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token function">dateAdd</span><span class="token punctuation">(</span><span class="token keyword keyword-new">new</span> <span class="token class-name">Date</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token string">"minute"</span><span class="token punctuation">,</span> <span class="token number">10</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token keyword control-flow keyword-if">if</span> <span class="token punctuation">(</span>cachedTermInfo<span class="token punctuation">.</span><span class="token property-access">length</span> <span class="token operator">&gt;</span> <span class="token number">0</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
                <span class="token console class-name">console</span><span class="token punctuation">.</span><span class="token method function property-access">log</span><span class="token punctuation">(</span>cachedTermInfo<span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword keyword-this">this</span><span class="token punctuation">.</span><span class="token method function property-access">setState</span><span class="token punctuation">(</span><span class="token punctuation">{</span> terms<span class="token operator">:</span> cachedTermInfo <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
    <span class="token punctuation">}</span>

public componentDidMount() {

this.setState({}, async () => {

// this portion is responsible for getting terms from term store

const cachedTermInfo = await this.store.local.getOrPut(myKey, () => {

return sp.termStore.groups.getById(this.props.termGroupId).sets.getById(this.props.termSetId).getAllChildrenAsOrderedTree({ retrieveProperties: true });

}, dateAdd(new Date(), "minute", 10));

if (cachedTermInfo.length > 0) {

console.log(cachedTermInfo);

this.setState({ terms: cachedTermInfo });

}

});

}

Step 7 – Render Terms using Command Bar

Open GlobalNav.tsx file.

Add below code before default class.

Create new method menuItems() in GlobalNav.tsx file.

Update render() method in GlobalNav.tsx file.

Step 8 – Test Solution

Open “../config/serve.json” file and update a couple of properties.

Update pageUrl Property and Properties,

Run below command in Visual Studio Code Terminal.

Copy URL which is highlighted in yellow and paste it into the browser.

Conclusion

We have implemented the SPFx solution and get terms from the term store using PnP and render items in the command bar which is fluent UI control.

SharePoint Hosting – Use ULS Log Viewer With SharePoint Server 2016

Jul 15th

Posted by Peter in Other Related Post

SharePoint 2016 provides diagnostic logging services to debug and isolate the issues among the farm. we will configure it from monitoring section in Central Administration. As part of it, we will specify the situation wherever the trace logs are going to be stored. In production, it’ll be a decent plan to stay it in a high capacity disk.

Once logging has been in place, it’ll produce the log files in real time, depending upon the severity of the events. we will go to the log location and find the recently updated log file to work on an existing issue in the farm.

However, opening it up in a notepad is going to create a tough time isolating the error as it is flooded with event logs.

To alleviate this issue, we can make use of a log viewer. There were many log viewers available for SharePoint 2013, however, not all of them are reusable with SharePoint 2016. One of the log viewers, intended for SharePoint 2013 but can be used with SharePoint 2016, is the ULS log viewer from Microsoft which can be downloaded from here. ULS stands for Unified Logging Service.

Once the log viewer is installed and opened, it will ask for the log file location from which the log files should be picked up. Specify the log folder path and click on OK.

This will load the logs into the ULS log viewer and we can easily browse through it to isolate the issues.

We can also find the issues by severity. Clicking on the severity icons in the top menu bar will highlight the issue accordingly. Critical issues will be highlighted, as shown below. This helps to identify and pick the needed ones from the large pool of event logs.

SharePoint 2016 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2016 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2016 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2016 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2016 plans as well as dedicated SharePoint 2016 Foundation options.

SharePoint 2013 Hosting – HostForLIFE.eu :: Working With SharePoint And ChartJS

Jul 8th

Posted by Peter in Other Related Post

In this post, we will see how we can represent SharePoint data in graphical form. Now, Create a custom SharePoint list ‘TaskDetails’ with the below details.

Column Name Type
Title Single line
status Choice

Add list items into ‘TaskDetails’.

Then add the below HTML elements on the page. <div>

        <canvas id="AssetStatus" width="500" height="500"></canvas>          
    </div>  
    <div id="chartjs-legend" class="noselect" ></div>

</div>

Add reference for jQuery and ChartJS plugin.

    <script type="text/javascript" src="jquery-1.7.2.min.js"> </script>  
    <script type="text/javascript" src="Chart.js"></script>

1 2	<script type="text/javascript" src="jquery-1.7.2.min.js"> </script> <script type="text/javascript" src="Chart.js"></script>

Code for getting SharePoint ‘TaskDetails’ list data using Rest API.

   $.ajax({  
        url: "<Add SharePoint Site Url>/_api/Web/Lists/GetByTitle('TaskDetails')/items",  
        type: "Get",  
        headers: {  
            "accept": "application/json;odata=verbose",  
        },  
        success: function (data) {  
            LoadChart(data);  
        },  
        error: function (err) {  
            //show error  
        }  
    });

$.ajax({

url: "<Add SharePoint Site Url>/_api/Web/Lists/GetByTitle('TaskDetails')/items",

type: "Get",

headers: {

"accept": "application/json;odata=verbose",

success: function (data) {

LoadChart(data);

error: function (err) {

//show error

}

});

Convert data into chartJS dataset and load the chart.

    var LoadChart = function (data) {  
                var items = [];  
                var statuses = [];  
                var chartData = [];  
                var temp = "";  
      
                //Loop through items to find unique statuses  
                for (var i = 0; i < data.d.results.length; i++) {  
                    items.push(data.d.results[i]);  
                    if (statuses.filter(findStatus(data.d.results[i].status)).length > 0) {  
                        continue;  
                    }  
                    temp = data.d.results[i].status;  
                    statuses.push(temp);  
                }  
      
                function findStatus(arg) {  
                    return function (items) {  
                        return items.indexOf(arg) > -1;  
                    }  
                }  
                var clrs = ["#3e95cd", "#8e5ea2", "#3cba9f", "#e8c3b9", "#c45850"];  
                for (var i = 0; i < statuses.length; i++) {  
                    var tempCount = items.filter(findStatusInData(statuses[i])).length;  
                    var object = {  
      
                        value: tempCount,  
                        color: clrs[i],  
                        label: statuses[i]  
                    }  
                    chartData.push(object);  
                }  
      
                function findStatusInData(arg) {  
                    return function (items) {  
                        return items.status.indexOf(arg) > -1;  
                    }  
                }  
      
                var ctx = document.getElementById('AssetStatus').getContext("2d");  
                var chart = new Chart(ctx).Doughnut(chartData, {});  
      
                document.getElementById("chartjs-legend").innerHTML = chart.generateLegend();  
      
            }

var LoadChart = function (data) {

var items = [];

var statuses = [];

var chartData = [];

var temp = "";

//Loop through items to find unique statuses

for (var i = 0; i < data.d.results.length; i++) {

items.push(data.d.results[i]);

if (statuses.filter(findStatus(data.d.results[i].status)).length > 0) {

continue;

}

temp = data.d.results[i].status;

statuses.push(temp);

}

function findStatus(arg) {

return function (items) {

return items.indexOf(arg) > -1;

}

var clrs = ["#3e95cd", "#8e5ea2", "#3cba9f", "#e8c3b9", "#c45850"];

for (var i = 0; i < statuses.length; i++) {

var tempCount = items.filter(findStatusInData(statuses[i])).length;

var object = {

value: tempCount,

color: clrs[i],

label: statuses[i]

}

chartData.push(object);

}

function findStatusInData(arg) {

return function (items) {

return items.status.indexOf(arg) > -1;

}

var ctx = document.getElementById('AssetStatus').getContext("2d");

var chart = new Chart(ctx).Doughnut(chartData, {});

document.getElementById("chartjs-legend").innerHTML = chart.generateLegend();

}

And this is the output:

The integrated code will be as below.

 <!DOCTYPE html>  
      
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml">  
    <head>  
        <script type="text/javascript" src="jquery-1.7.2.min.js"> </script>  
        <script type="text/javascript" src="Chart.js"></script>  
        <script type="text/javascript" >  
      
            $.ajax({  
                url: "<Add SharePoint Site Url>/_api/Web/Lists/GetByTitle('TaskDetails')/items",  
                type: "Get",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                },  
                success: function (data) {  
                    LoadChart(data);  
                },  
                error: function (err) {  
                    //show error  
                }  
            });  
      
            var LoadChart = function (data) {  
                var items = [];  
                var statuses = [];  
                var chartData = [];  
                var temp = "";  
      
                //Loop through items to find unique statuses  
                for (var i = 0; i < data.d.results.length; i++) {  
                    items.push(data.d.results[i]);  
                    if (statuses.filter(findStatus(data.d.results[i].status)).length > 0) {  
                        continue;  
                    }  
                    temp = data.d.results[i].status;  
                    statuses.push(temp);  
                }  
      
                function findStatus(arg) {  
                    return function (items) {  
                        return items.indexOf(arg) > -1;  
                    }  
                }  
                var clrs = ["#3e95cd", "#8e5ea2", "#3cba9f", "#e8c3b9", "#c45850"];  
                for (var i = 0; i < statuses.length; i++) {  
                    var tempCount = items.filter(findStatusInData(statuses[i])).length;  
                    var object = {  
      
                        value: tempCount,  
                        color: clrs[i],  
                        label: statuses[i]  
                    }  
                    chartData.push(object);  
                }  
      
                function findStatusInData(arg) {  
                    return function (items) {  
                        return items.status.indexOf(arg) > -1;  
                    }  
                }  
      
                var ctx = document.getElementById('AssetStatus').getContext("2d");  
                var chart = new Chart(ctx).Doughnut(chartData, {});  
      
                document.getElementById("chartjs-legend").innerHTML = chart.generateLegend();  
      
            }  
      
        </script>  
         <style type="text/css">  
           ol,  
           ul {  
               list-style: none;  
               margin: 0;  
               padding: 0;  
               text-align: center;  
           }  
      
           li {  
               display: inline-table;  
           }  
           .noselect {  
               -webkit-touch-callout: none;  
               -webkit-user-select: none;  
               -khtml-user-select: none;  
               -moz-user-select: none;  
               -ms-user-select: none;  
               user-select: none;  
           }  
           #chartjs-legend {  
               position: absolute;  
               width: 100%;  
               bottom: 10%;  
           }  
      
               #chartjs-legend li {  
                   cursor: pointer;  
                   margin: 10px 4px;  
               }  
      
                   #chartjs-legend li span {  
                       position: relative;  
                       padding: 6px 20px;  
                       border-radius: 13px;  
                       color: white;  
                       z-index: 2;  
                   }  
       </style>  
        <meta charset="utf-8" />  
        <title></title>  
    </head>  
    <body>  
        <div>  
            <canvas id="AssetStatus" width="500" height="500"></canvas>          
        </div>  
        <div id="chartjs-legend" class="noselect" ></div>  
    </body>  
    </html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

<!DOCTYPE html>

<head>

$.ajax({

url: "<Add SharePoint Site Url>/_api/Web/Lists/GetByTitle('TaskDetails')/items",

type: "Get",

headers: {

"accept": "application/json;odata=verbose",

success: function (data) {

LoadChart(data);

error: function (err) {

//show error

}

});

var LoadChart = function (data) {

var items = [];

var statuses = [];

var chartData = [];

var temp = "";

//Loop through items to find unique statuses

for (var i = 0; i < data.d.results.length; i++) {

items.push(data.d.results[i]);

if (statuses.filter(findStatus(data.d.results[i].status)).length > 0) {

continue;

}

temp = data.d.results[i].status;

statuses.push(temp);

}

function findStatus(arg) {

return function (items) {

return items.indexOf(arg) > -1;

}

var clrs = ["#3e95cd", "#8e5ea2", "#3cba9f", "#e8c3b9", "#c45850"];

for (var i = 0; i < statuses.length; i++) {

var tempCount = items.filter(findStatusInData(statuses[i])).length;

var object = {

value: tempCount,

color: clrs[i],

label: statuses[i]

}

chartData.push(object);

}

function findStatusInData(arg) {

return function (items) {

return items.status.indexOf(arg) > -1;

}

var ctx = document.getElementById('AssetStatus').getContext("2d");

var chart = new Chart(ctx).Doughnut(chartData, {});

document.getElementById("chartjs-legend").innerHTML = chart.generateLegend();

}

</script>

ol,

ul {

list-style: none;

margin: 0;

padding: 0;

text-align: center;

}

li {

display: inline-table;

}

.noselect {

-webkit-touch-callout: none;

-webkit-user-select: none;

-khtml-user-select: none;

-moz-user-select: none;

-ms-user-select: none;

user-select: none;

}

#chartjs-legend {

position: absolute;

width: 100%;

bottom: 10%;

}

#chartjs-legend li {

cursor: pointer;

margin: 10px 4px;

}

#chartjs-legend li span {

position: relative;

padding: 6px 20px;

border-radius: 13px;

color: white;

z-index: 2;

}

</style>

</head>

<body>

<div>

</div>

</body>

</html>

Refer to the attached resources for more.

SharePoint 2013 Hosting – HostForLIFE.eu :: Format The SharePoint Modern Site List Form Using JSON Formatting

Mar 3rd

Posted by Peter in Other Related Post

We can configure the SharePoint modern site list form using JSON formatting, which has the following use cases:

If you want to implement multiple column forms rather than existing single column look and feel
If you want to hide and show field/column-based forms in a simple and easy way
If you don’t have Power App license but still want to change some look and feel of list forms
If you want to group the fields/columns in the list form

Steps to use JSON formatting to change the form look and feel follows the below steps:

Open the New form of list

See the form is showing only one column view

Click on the highlighted icon and choose the below option

The below screen will appear, It will shows a dropdown with three options namely
- Header
- Body
- Footer

Copy the JSON and paste in the field for header

{  
    "debugMode": true,  
    "elmType": "div",  
    "attributes": {  
        "class": "ms-borderColor-neutralTertiary"  
    },  
    "style": {  
        "width": "99%",  
        "border-top-width": "0px",  
        "border-bottom-width": "1px",  
        "border-left-width": "0px",  
        "border-right-width": "0px",  
        "border-style": "solid",  
        "margin-bottom": "16px",  
        "background-color": "#026d70"  
    },  
    "children": [{  
        "elmType": "div",  
        "style": {  
            "display": "flex",  
            "box-sizing": "border-box",  
            "align-items": "center"  
        },  
        "children": [{  
            "elmType": "div",  
            "attributes": {  
                "iconName": "Group",  
                -Use icon as per your requirement "class": "ms-fontSize-42 ms-fontWeight-regular ms-fontColor-white",  
                "title": "Details"  
            },  
            "style": {  
                "flex": "none",  
                "padding": "0px",  
                "padding-left": "5px",  
                "height": "36px"  
            }  
        }]  
    }, {  
        "elmType": "div",  
        "attributes": {  
            "class": "ms-fontColor-neutralSecondary ms-fontWeight-bold ms-fontSize-24"  
        },  
        "style": {  
            "box-sizing": "border-box",  
            "width": "100%",  
            "text-align": "left",  
            "padding": "21px 12px",  
            "overflow": "hidden",  
            "color": "white"  
        },  
        "children": [{  
            "elmType": "div",  
            "txtContent": "New Form" - This is the Form Title  
        }]  
    }]  
}

{

"debugMode": true,

"elmType": "div",

"attributes": {

"class": "ms-borderColor-neutralTertiary"

"style": {

"width": "99%",

"border-top-width": "0px",

"border-bottom-width": "1px",

"border-left-width": "0px",

"border-right-width": "0px",

"border-style": "solid",

"margin-bottom": "16px",

"background-color": "#026d70"

"children": [{

"elmType": "div",

"style": {

"display": "flex",

"box-sizing": "border-box",

"align-items": "center"

"children": [{

"elmType": "div",

"attributes": {

"iconName": "Group",

-Use icon as per your requirement "class": "ms-fontSize-42 ms-fontWeight-regular ms-fontColor-white",

"title": "Details"

"style": {

"flex": "none",

"padding": "0px",

"padding-left": "5px",

"height": "36px"

}

}]

}, {

"elmType": "div",

"attributes": {

"class": "ms-fontColor-neutralSecondary ms-fontWeight-bold ms-fontSize-24"

"style": {

"box-sizing": "border-box",

"width": "100%",

"text-align": "left",

"padding": "21px 12px",

"overflow": "hidden",

"color": "white"

"children": [{

"elmType": "div",

"txtContent": "New Form" - This is the Form Title

}]

}

The above JSON is self-explanatory, which has three div.’s, first div is for main container div for header and next two for below…

- For Icon
- For Title

Click on preview button to see the applied JSON configuration to header.

For Body, copy and paste the below JSON, choose Body from dropdown first

{  
    "sections": [{  
        "displayname": "Group name 1",  
        "fields": ["Field Display name1", "Field Display name2"]  
    }, {  
        "displayname": "Group name 2",  
        "fields": ["Field Display name1", "Field Display name2"]  
    }]  
}

{

"sections": [{

"displayname": "Group name 1",

"fields": ["Field Display name1", "Field Display name2"]

}, {

"displayname": "Group name 2",

"fields": ["Field Display name1", "Field Display name2"]

}]

}

Here in the above JSON, Section is used to divide the fields in multi column views. Use the column display name to put that column section if any field not mention the section then that field/column will automatically display in the last section.

You can see the JSON is self-explanatory so you can add any number of sections here in the JSON.

For Footer copy and pasting below JSON, buttons will not be associated with any part; i.e. it is not associated with Header, Body or Footer section.

{  
    "debugMode": true,  
    "elmType": "div",  
    "style": {  
        "width": "100%",  
        "text-align": "left",  
        "overflow": "hidden",  
        "border-top-width": "1px"  
    },  
    "children": [{  
        "elmType": "div",  
        "style": {  
            "width": "100%",  
            "margin-top": "20px",  
            "margin-bottom": "10px",  
            "height": "4px",  
            "background-color": "#026d70"  
        }  
    }]  
}

{

"debugMode": true,

"elmType": "div",

"style": {

"width": "100%",

"text-align": "left",

"overflow": "hidden",

"border-top-width": "1px"

"children": [{

"elmType": "div",

"style": {

"width": "100%",

"margin-top": "20px",

"margin-bottom": "10px",

"height": "4px",

"background-color": "#026d70"

}

}]

}

The above JSON is just to add some border margin below the body, and you can refer the header JSON to add div children in this section if you want. Just complete all these steps and your list form will look better than the default list form, just click on Save button as highlighted in the below screen.

Format The SharePoint Modern Site List Form Using JSON Formatting

This formatting will apply to all three forms of SharePoint list form.

For more information please visit the Microsoft site.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

Jan 22nd

Posted by Peter in Other Related Post

This article will explain the PowerShell script that searches for files within document libraries in SharePoint (farm level, site collection level, web level etc.) based on the search parameters you provide. It can also be used for searching in SharePoint for any files with specified extension. The results are returned in .CSV format.

Examples of scenarios

Search the entire farm for files that have names like “Training Copy”.
Search the site collection http://sharepoint.mydreambox.com/sites/site1 for all PDF files, RDL files, etc.
Search the web http://sharepoint.mydreambox.com/sites/site1/web1 for the file named “AXL8rt.docx”, etc.

Usage of the Script

Replace the $webApp, $sites, etc. with appropriate values
Replace the $searchKey with the desired search queries or file extension that is to be searched for
Make sure the account that is running these scripts have necessary privileges in SharePoint

Script use cases

The code is presented for four different cases,

Searching for an entire farm
Searching within a web application
Searching within a site collection
Searching within a web

Output

The output will be in the form of a CSV file, as displayed below. It will contain all the file location URLs.

Case I – For searching within the entire farm

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$sites = Get-SPSite -Limit All
$searchKey = ".rdl"
$results = @()

foreach ($site in $sites)
{
foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails
}
}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case II - For searching within a Web Application

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$webApp = "http://sharepoint.dreambox.com"
$sites = Get-SPSite -WebApplication $webApp -Limit All
$searchKey = "Self Improvement"
$results = @()

foreach ($site in $sites)
{
foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails

}
}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$sites = Get-SPSite -Limit All

$searchKey = ".rdl"

$results = @()

foreach ($site in $sites)

{

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File Location” = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case II - For searching within a Web Application

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$webApp = "http://sharepoint.dreambox.com"

$sites = Get-SPSite -WebApplication $webApp -Limit All

$searchKey = "Self Improvement"

$results = @()

foreach ($site in $sites)

{

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File Location” = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case III – For searching within a Site Collection

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1”
$searchKey = ".docx"
$results = @()


foreach ($web in $site.AllWebs)
{
Write-Host Searching within $web.Url
foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails

}
}
}
}
}
$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$site = Get-SPSite “http://sharepoint.dreambox.com/sites/site1”

$searchKey = ".docx"

$results = @()

foreach ($web in $site.AllWebs)

{

Write-Host Searching within $web.Url

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File Location” = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

Case IV – For searching within a Web

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}

$web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1”
$searchKey = ".pdf"
$results = @()

foreach ($list in $web.Lists)
{
if($list.BaseType -eq "DocumentLibrary")
{
foreach($item in $list.Items)
{
if($item.Name.Contains($searchKey))
{
$RowDetails = @{
“File Location” = $web.Url + "/" + $item.Url
}
$results += New-Object PSObject –Property $RowDetails
}
}
}
}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$web = Get-SPWeb “http://sharepoint.dreambox.com/sites/site1/web1”

$searchKey = ".pdf"

$results = @()

foreach ($list in $web.Lists)

{

if($list.BaseType -eq "DocumentLibrary")

{

foreach($item in $list.Items)

{

if($item.Name.Contains($searchKey))

{

$RowDetails = @{

“File Location” = $web.Url + "/" + $item.Url

}

$results += New-Object PSObject –Property $RowDetails

}

$results | Export-CSV –Path C:\MySearchedFiles.csv -NoTypeInformation

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

Jan 7th

Posted by Peter in Other Related Post

In this blog, we are going to learn how to copy the attachments from a single list item to SharePoint library using PnP PowerShell. The following snippet helps, you to get the attachments from a list item and uploads to the shared Documents library in a current context site.

$cred = Get-Credential
Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2
$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

$cred = Get-Credential

Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2

$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

After running the powershell command, it asks us to confirm the sourceurl and target url. If the file already exists in the targeturl, we have to add -OverwriteIfAlreadyExists $true to avoid the file already exists error.

Below is the example copies the two attachments from the single list item to the folder within a SharePoint library.

Other Related Post

SharePoint Hosting – Global Navigation In Modern SharePoint Using SPFx, PnP And Fluent UI

Steps

Conclusion

SharePoint Hosting – Use ULS Log Viewer With SharePoint Server 2016

SharePoint 2016 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Working With SharePoint And ChartJS

SharePoint 2013 Hosting – HostForLIFE.eu :: Format The SharePoint Modern Site List Form Using JSON Formatting

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

BLOGROLL

Featured On

Other Related Post

SharePoint Hosting – Global Navigation In Modern SharePoint Using SPFx, PnP And Fluent UI

Steps

Conclusion

SharePoint Hosting – Use ULS Log Viewer With SharePoint Server 2016

SharePoint 2016 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Working With SharePoint And ChartJS

SharePoint 2013 Hosting – HostForLIFE.eu :: Format The SharePoint Modern Site List Form Using JSON Formatting

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Custom Search Script in SharePoint 2013?

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

BLOGROLL

Featured On

Tags