#2. PnP Powershell cmdlets with SharePoint Online

Introduction

In this article you will learn via demo application, 

1. Create a subsite using PnP Powershell Modular approach.
2. Delete a subsite using PnP Powershell Modular approach.
3. Create and Use a Bat and CSV file as input.


SharePoint Patterns and Practice (PnP) contains a library of PowerShell Cmdlets which allowed to perform operation towards SharePoint. These Cmdlets use CSOM and works for both SharePoint Online and On Premises.

Previous article Link can be found here:- http://manojmittalblogs.blogspot.com/2018/10/1-pnp-powershell-cmdlets-with.html

Stay tune...

#1. PnP Powershell cmdlets with SharePoint Online

Introduction

In this article you will learn via demo application, How to install PnP Powershell and  get start with basic operations.

SharePoint Patterns and Practice (PnP) contains a library of PowerShell Cmdlets which allowed to perform operation towards SharePoint. These Cmdlets use CSOM and works for both SharePoint Online and On Premises.

Stay tuned with series of videos.

I’ll be talking on SharePoint Saturday Bangalore

Hello Folks,

We’re all set for SPS (SharePoint Saturday) Bangalore on Sep 1st 2018 at Microsoft’s new Office in Bangalore where I would be taking on How to build intelligent Azure Bot using Cognitive Services i.e. LUIS and QnA Maker with SharePoint Online . If you’re interested in attending this event , please use the link below to enroll yourself . We have many great sessions lined up for you on SharePoint and Office 365 .

Registration link :_ http://www.spsevents.org/city/bangalore/bangalore2018

Sessions :_ http://www.spsevents.org/city/Bangalore/Bangalore2018/sessions

Schedule :_ http://www.spsevents.org/city/Bangalore/Bangalore2018/schedule

See you all on Sep 1st ….

Happy Coding

Turn OOTB Comment Section From SharePoint Online Modern Page On or Off

The comments section is an important part of any webpage. It appears in all the modern pages by default. However, we can easily turn this feature on or off using the below simple steps.

Step1
Edit the page.

Step 2
The page owner can see the "Turn on or off" option parallel to the comment section.

Step 3
Select the Turn Off toggle.

Step 4
Publish the page and you will not see any comment section.

Happy Coding.

Remove Header Image Banner From SharePoint Modern Pages

SharePoint Online Modern pages have header image banners in all modern pages;  i.e., Communication or Team Sites. Header image banner needs a background image or text, it takes almost 40% of the page, and we can’t remove this section using User Interface.

If you want to turn this section ON or OFF, it is possible using PnP PowerShell command. Basically, it allows us to change the page layout from Article to Home. The homepage layout doesn’t have a header image banner section.

Remove the Header Image Banner Section

Open SharePoint Online Management Shell and run the below command in sequence.

1. # Connect to the site  
2. Connect-PnPOnline https://mittal1201.sharepoint.com/sites/teamsite  
3. # List all pages, and find the id of the modern page  
4. Get-PnPListItem -List SitePages  
5. # Change layout from "Article" to "Home" to remove top banner  
6. Set-PnPListItem -List SitePages –Identity <id> -Values @{"PageLayoutType"="Home"} 

Screenshot for your reference.

After executing this command, refresh the page. You will not find the header image banner.

Happy Coding.

Online Webinar SharePoint Framework Part-1

Recording of online webinar @ SharePoint Framework -Part -1

Here you can find out presentation link  https://www.slideshare.net/ManojMittal12/free-online-sharepoint-framework-webinar

Global Azure Boot Camp 2018

I will be taking on Global Azure Boot Camp at Bangalore  this year 2018

The details about the event as well as the agenda can be found in this link : http://bengaluru.azurebootcamp.net/

Fetch azure SQL data into SharePoint Online

This tutorial demonstrate, How to fetch azure SQL data into SharePoint Online using Business Connectivity Services and Secure Store Services.

SharePoint Secure Store Service

Quoting MSDN, the definition of SharePoint Secure Store Service is:

"Secure Store Service is a shared service that provides storage and mapping of credentials such as account names and passwords. It enables you to securely store data that provides credentials required for connecting to external systems and associating those credentials to a specific identity or group of identities. It is very common for solutions to try to authenticate to an external system in which the current user is known differently or has a different account for authentication. In such cases, Secure Store Service can be used to store and map user credentials required by the external system. You can configure Secure Store Service so that multiple users can access an external system by using a single set of credentials on that external system."

Business Connectivity Services

Business Connectivity Services (BCS) connections to data sources, such as SQL Azure databases or Windows Communication Foundation (WCF) web services, that are outside the SharePoint site.

Explore LUIS

Language understanding Intelligent System (LUIS)

The interaction between users and bots is mostly free-form, so bots need to understand language naturally and contextually. The Cognitive Service Language APIs provide powerful language models to determine what users want, to identify concepts and entities in a given sentence, and ultimately to allow your bots to respond with the appropriate action. 

My Previous article can be find here

I have explained about Bot framework environment setup & QnA configuration in the below articles -
1. FAQ based Bot Application Using QnA Maker - Part One
2. Setup Bot Framework Development Environment Using .Net (C#) - Part Two
3. How to add or remove synonyms or alternative keywords to QnAMaker 
4. Add Rich Card (Image or Video) to Chat Bot Response

Build Intelligent Microsoft Azure Bot Using LUIS and QnAMaker

Introduction
The interaction between users and bots is mostly free-form, so bots need to understand language naturally and contextually

QnAMaker  This service enables developers to build, train and publish a simple question and answer bot based on FAQ URLs, structured documents . 

LUIS Language Understanding Intelligent Service (LUIS) enables developers to build smart applications that can understand human language and react accordingly to user requests. 

My Previous article can be find here

I have explained about Bot framework environment setup & QnA configuration in the below articles -
1. FAQ based Bot Application Using QnA Maker - Part One
2. Setup Bot Framework Development Environment Using .Net (C#) - Part Two
3. How to add or remove synonyms or alternative keywords to QnAMaker 
4. Add Rich Card (Image or Video) to Chat Bot Response
5. Explore Luis