SharePoint Online: How to Create a Subsite using PowerShell?

May 31, 2016    , , , ,
Requirement: Create a Subsite in SharePoint Online using PowerShell. How to Create a Subsite in SharePoint Online? Subsites in SharePoint Online can be created within any existing root site or subsite. By default, site owners (or users with Full control or Manage Hierarchy) have the permissions to create subsites. To add a subsite in SharePoint online, follow these steps: Sign-in to your SharePoint Online site as Site Collection Administrator/Site Owner >> Navigate to the site under which the new subsite is to be created. Click on Site Settings Gear Icon >> Choose "Site Contents" (or Click on the Site Content link from the Quick Launch) Scroll down to the bottom and click on "Create Subsite" link Provide the Name, description, URL and 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. It&
SharePoint Online: How to Create a Subsite using PowerShell? SharePoint Online: How to Create a Subsite using PowerShell? Reviewed by Salaudeen Rajack on May 31, 2016 Rating: 5

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

May 29, 2016    , , , , ,
Requirement : SharePoint Online PowerShell to Update a List View 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. Now, lets add a column to SharePoint Online view using PowerShell. SharePoint Online: PowerShell to Add a Field to 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
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 May 29, 2016 Rating: 5

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

May 29, 2016    , , , ,
Requirement: Enable Versioning on all lists in SharePoint online site. How to Enable Versioning on a List or Library in SharePoint? Version History feature in SharePoint allows you to access previous saved copy of a document or list item. By default versioning is enabled on your document library in SharePoint Online. When a save operation happens, SharePoint creates new version along with metadata such as, who saved the item, when it was created, etc. 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 Histor
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 May 29, 2016 Rating: 5

SharePoint Online: Delete a Subsite using PowerShell

May 29, 2016    , , , ,
Requirement: SharePoint Online PowerShell to Remove Subsite How to Delete a Subsite in SharePoint Online? Any user with Full Control or Manage Hierarchy permissions within a site can delete the site in SharePoint Online. To delete a subsite from 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. Remove SharePoint Online Subsite using Sites and Workspaces: You can also remove a subsite in SharePoint Online using "Sites and Workspaces" link. Here is how: Navigate to the parent site which contains the subsite you want to delete. Click on Settings Gear >> Select Site Settings On the Site Settings page, under Site Administration sect
SharePoint Online: Delete a Subsite using PowerShell SharePoint Online: Delete a Subsite using PowerShell Reviewed by Salaudeen Rajack on May 29, 2016 Rating: 5

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

May 29, 2016    ,
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 May 29, 2016 Rating: 5

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

May 28, 2016    , , , , ,
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 May 28, 2016 Rating: 5

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

May 14, 2016    , , , , ,
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 Unknown on May 14, 2016 Rating: 5

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

May 07, 2016    , , , , ,
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 May 07, 2016 Rating: 5

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

May 06, 2016    , , , ,
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 May 06, 2016 Rating: 5

SharePoint Online: PowerShell to Create a List View

May 02, 2016    , , , , ,
SharePoint Online Views helps to organize columns together and present the data with sort, group and filtering capabilities. Views can be either Private or Public - A public view is available to all users, whereas a private view is available only to the user who created it. When you create a list or library it comes with default views E..g "All Items" with certain columns. You can create any number of views to support different use cases in the list or library. How to Create View in SharePoint Online? To create a new view, do the following:  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 Share
SharePoint Online: PowerShell to Create a List View SharePoint Online: PowerShell to Create a List View Reviewed by Salaudeen Rajack on May 02, 2016 Rating: 5

SharePoint Online: How to Break Permission Inheritance using PowerShell?

May 01, 2016    , , , , , ,
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 May 01, 2016 Rating: 5

SharePoint Online: Grant Permission to List or Library using PowerShell

May 01, 2016    , , , , , ,
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 May 01, 2016 Rating: 5
Powered by Blogger.