kwizcom banner advertisement

SharePoint Online: How to Create a Subsite using PowerShell?

1:45 PM    , , ,
Requirement: Create a Subsite in SharePoint online using PowerShell. How to create a Subsite in SharePoint Online? To add a subsite in SharePoint online, follow these steps: Sign-in to your SharePoint online site as Site Collection Administrator/Site Owner Click on Site Settings Gear Icon >> Choose "Site Contents" Scroll down to the bottom and click on "Create Subsite" link Provide the Name, description, template for your new subsite. specify other optional settings such as Permissions, Navigation. Click on "Create" button at the bottom of the page to create a subsite in SharePoint online. Lets see the SharePoint online PowerShell to create subsite. SharePoint Online: PowerShell to create subsite: Let's create a subsite in SharePoint online using PowerShell. #Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll&
SharePoint Online: How to Create a Subsite using PowerShell? SharePoint Online: How to Create a Subsite using PowerShell? Reviewed by Salaudeen Rajack on 1:45 PM Rating: 5

SharePoint Online: Add-Remove Fields to List View using PowerShell

5:17 PM    , , , ,
How to Add or Remove Columns in SharePoint Online List View? To add or remove columns in SharePoint online list view, follow these steps: Navigate to your SharePoint Online List >> Click on Modify View button from List Tab of the ribbon In Modify View page, Select/Unselect the check boxes next to columns based on your requirement Click on Save to commit your changes. SharePoint Online: PowerShell Script to Add a Field to an Existing List View Here is the PowerShell to add a field to an existing List view in SharePoint online. #Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" ##Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/sites/Sales/" $ListName="Documents"
SharePoint Online: Add-Remove Fields to List View using PowerShell SharePoint Online: Add-Remove Fields to List View using PowerShell Reviewed by Salaudeen Rajack on 5:17 PM Rating: 5

SharePoint Online: Enable Versioning on All List and Libraries using PowerShell

3:18 PM    , , ,
Requirement: Enable Versioning on all lists in SharePoint online site. How to Enable Versioning on a List or Library in SharePoint? To enable versioning for a list or library in SharePoint online, Go to your document library >> Click the Library tab on the Ribbon >> Click on Library Settings. Under general Settings, click Versioning Settings link. From the Versioning Settings page, choose "Create major versions". Optionally, you can set a limit on number of versions. This enables SharePoint online document library versioning. Once versioning feature is enabled, you can select a document or a list item and click on "Version History" from the context menu or from the Ribbon to view versions created. PowerShell script to enable versioning on all lists and libraries in SharePoint online: #Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Cli
SharePoint Online: Enable Versioning on All List and Libraries using PowerShell SharePoint Online: Enable Versioning on All List and Libraries using PowerShell Reviewed by Salaudeen Rajack on 3:18 PM Rating: 5

SharePoint Online: Delete a Subsite using PowerShell

1:18 PM    , ,
How to delete subsite in SharePoint online? To delete a subsite SharePoint online: Click on Site Settings gear >> Choose "Site Settings". Click on "Delete this Site" link under "Site Actions" group. This leads you to the "Delete this site" page. Click on "Delete" button and confirm subsite deletion. and you'll get "Your Web site has been deleted." message in a while. This removes the subsite in SharePoint online. Lets see how to delete subsite in SharePoint Online using PowerShell! You need to have SharePoint Online Management Shell installed on your machine before executing these script. You can download it from here http://www.microsoft.com/en-in/download/details.aspx?id=35588 Delete a subsite in SharePoint online using PowerShell: While removing subsites in SharePoint online using web browser UI is relatively simpler, We may need PowerShell in certain cases, such as: When you have to delete
SharePoint Online: Delete a Subsite using PowerShell SharePoint Online: Delete a Subsite using PowerShell Reviewed by Salaudeen Rajack on 1:18 PM Rating: 5

Get "Created By" User Email, Display Name, Login ID in SharePoint using PowerShell

12:43 PM    ,
Requirement: Sometimes, You may to retrieve the User details such as User's Email, Account ID, Full name, etc from the Created by field. Here is the PowerShell script to get created by field values in SharePoint. PowerShell to Get "Created By" Field Value in SharePoint: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Configuration Parameters $WebURL = "http://portal.crescent.com/IQ/" $ListName = "Questionnaire" $ItemID = "147" #Get the Web, List, Item objects $Web= Get-SPWeb $WebURL $List= $web.Lists[$ListName] $Item = $List.GetItembyID($ItemID) #Get the "created by" Field value $Author = New-Object Microsoft.SharePoint.SPFieldUserValue($web, $Item["Author"]) #Get Email ID from Created By $Author.user.Email #Get Login ID $Author.User.LoginName #Get Created By Full Name $Author.User.Name
Get "Created By" User Email, Display Name, Login ID in SharePoint using PowerShell Get "Created By" User Email, Display Name, Login ID in SharePoint using PowerShell Reviewed by Salaudeen Rajack on 12:43 PM Rating: 5

How to Reload SharePoint Page Every 60 Seconds Automatically with JavaScript?

4:08 PM    , , , , ,
Requirement: For a monitoring dashboard, got a requirement to reload Intranet SharePoint site's home page for every five Minutes. Solution: Use this JavaScript placed in a Script editor or content editor web part to refresh a SharePoint page on every 60 seconds. Here is how to refresh current page in SharePoint step by step: Navigate to the target page you want to reload. Click on Settings gear and then click on "Edit Page" Under Insert Tab of the Ribbon, Click on "Web Part" and insert "Script Editor" web part from "Media and Content" group. Edit the script editor web part >> Edit snippet and place the below code in it <script type="text/javascript"> function refreshPage(){ location.reload(); } setTimeout(refreshPage, 60000); </script> Save and close the page. This refreshes a SharePoint page for every 60 seconds (or whatever you specify).
How to Reload SharePoint Page Every 60 Seconds Automatically with JavaScript? How to Reload SharePoint Page Every 60 Seconds Automatically with JavaScript? Reviewed by Salaudeen Rajack on 4:08 PM Rating: 5

How to Create External Lists from SQL Server using BCS in SharePoint 2016?

7:16 PM    , , , , ,
Business Data Connectivity Services enables SharePoint 2013/2016 and Office 2013/2016 clients to interact with data that doesn't live in SharePoint.  BCS allows you to integrate external data into SharePoint, External list provides familiar list like user experience. Lets see how to create a External List in SharePoint that grabs the data stored in SQL Server Database and display it in SharePoint 2016 without writing a single line of code. Prerequisites: Before creating an external content type-External List, You need to have Business Data Connectivity Service (BCS) application and/or secure store service application configured in your SharePoint farm! Here is how to Create and configure BDC service application in SharePoint 2016 Step 1: Create External Content Type in SharePoint Designer 2013: Follow these steps to create an External Content Type using SharePoint Designer 2013. Open your SharePoint 2016 site in SharePoint Designer 2013 Select External Content Types in t
How to Create External Lists from SQL Server using BCS in SharePoint 2016? How to Create External Lists from SQL Server using BCS in SharePoint 2016? Reviewed by Salaudeen Rajack on 7:16 PM Rating: 5

Create Business Data Connectivity Service (BCS) Application in SharePoint 2016

4:58 PM    , , , , ,
The Business Data Connectivity (BDC or BCS) service application in SharePoint 2016 enables us to connect and manipulate with external line of business data sources such as SQL Server, web services, WCF Service, SOAP, REST Service Connection, XML file connection, oAuth and other proprietary data sources that are accessed by custom .NET assemblies from SharePoint. Using BDC, you can use SharePoint 2016 and Office clients as interfaces with data that doesn’t live in SharePoint. External content types are the core of BDC, It interacts with data through external content types which allows the interaction with external data in SharePoint lists. During SharePoint farm configuration, If you ran Farm configuration wizard to configure all services then you may already have BDC service application configured for you by SharePoint. You can verify if its created already by going to:     Open SharePoint Central administration site     Click on Application Management >> Service Application
Create Business Data Connectivity Service (BCS) Application in SharePoint 2016 Create Business Data Connectivity Service (BCS) Application in SharePoint 2016 Reviewed by Salaudeen Rajack on 4:58 PM Rating: 5

Create BDC (BCS) Service Application in SharePoint 2013/2016 using PowerShell

9:13 PM    , , , ,
Business Data Connectivity Services service application provides centralized infrastructure to connect and manipulate with external line of business data sources through external list concept. Here is the PowerShell script to create Business Data Connectivity Service Application in SharePoint 2016. PowerShell script to create BDC Service Application in SharePoint 2013 / 2016: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $ServiceAppName = "Crescent BDC Service Application" $ServiceAppProxyName = "Crescent BDC Service Application Proxy" $AppPoolAccount = "Crescent\SP16-AppPool" $AppPoolName = "Service Application App Pool" $DatabaseServer = "SP16-SQL001" $DatabaseName = "SP16_BDC_ServiceApp" #Check if Managed account is registered already Write-Host -ForegroundColor Yellow "Checking if Application Pool Accounts already exists" $AppPoolAccount = Get-SPManagedA
Create BDC (BCS) Service Application in SharePoint 2013/2016 using PowerShell Create BDC (BCS) Service Application in SharePoint 2013/2016 using PowerShell Reviewed by Salaudeen Rajack on 9:13 PM Rating: 5

SharePoint Online: PowerShell to Create a List View

3:30 PM    , , , ,
How to Create View in SharePoint Online?  Navigate to the list in which you want to create new View in SharePoint Online. Under List Tab, Click on "Create View" button from the Ribbon. In the next page, Choose a view type such as "Standard view", "Datasheet View", "Gantt View", etc. Provide the Name to your view, Select Fields to display in the view, set Sort and Filter options, and click on "OK" to create view in SharePoint Online List. SharePoint Online: PowerShell to Create a List View Here is how to create a list view using PowerShell in SharePoint Online. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Custom function to Create List view in SharePoint On
SharePoint Online: PowerShell to Create a List View SharePoint Online: PowerShell to Create a List View Reviewed by Salaudeen Rajack on 3:30 PM Rating: 5

SharePoint Online: How to Break Permission Inheritance using PowerShell?

8:19 PM    , , , ,
Requirement: Grant permissions at list or library level to users and groups in SharePoint online. The particular user group has read access at site level and the requirement is to provide Edit access rights on specified lists and libraries. Break permission inheritance in SharePoint Online: When you provide permissions at the site collection, any securable object under the hierarchy, such as sub-sites, lists and libraries, folders, documents & items inherit their permissions from their parent. However, there are situations where you want to provide granular permission to any of these securable objects by assigning unique permissions. Providing unique permissions at list or item level consists of two steps: As a first step stop inheriting permissions from the parent and then add permissions to users and/or groups. Here is how to break permission inheritance in sharepoint online: Navigate to the SharePoint library where your documents are stored Select the document >>
SharePoint Online: How to Break Permission Inheritance using PowerShell? SharePoint Online: How to Break Permission Inheritance using PowerShell? Reviewed by Salaudeen Rajack on 8:19 PM Rating: 5

SharePoint Online: Grant Permission to List or Library using PowerShell

7:16 PM    , , , ,
Granting access to lists, libraries and individual items in SharePoint online: There are times you may want to grant permissions at list or library level to users and groups in SharePoint online. Say for e.g. You may want to provide read access at site level and edit rights on individual list level. So, to grant permissions to lists and libraries, as a first step we have to stop inheriting permissions from its parent and then apply unique security permissions to any level underneath site collection such as: Sub-site, List, Library or list items. How to grant access to a list or library in SharePoint online: Go to the target list or library settings (From the library page, Click on Library tab on the ribbon >> Select list settings. If modern UI is enabled, head on to Site connects and click settings from the list context menu) On the List Settings page, in the permissions and management group, click on "Permissions for this list" link. In the permissions page, if
SharePoint Online: Grant Permission to List or Library using PowerShell SharePoint Online: Grant Permission to List or Library using PowerShell Reviewed by Salaudeen Rajack on 7:16 PM Rating: 5
Powered by Blogger.