Requirement: Export List Templates in SharePoint Online using PowerShell List templates in SharePoint Online enables you to reuse any list with its fields, formulas, formatting, and optionally data in other site collections without re-creating the list again. List Templates should be downloaded and uploaded to another sites in order to create lists from it. Here is how to download a list template SharePoint Online. How to Export a List Template in SharePoint Online? To download a list template from SharePoint Online site, Click on Settings gear >> Site settings page >> Click on "List Templates" under Web Designer Galleries (List template gallery in SharePoint Online URL: https://yourdomain.sharepoint.com/_catalogs/lt/Forms/AllItems.aspx) In the "List templates Gallery", Click on "Name" column link for the list template you want to download. This triggers file download prompt, click Save to download the file. List Templates fe
Requirement: Import List Templates in SharePoint Online using PowerShell Why we need list templates in SharePoint Online? Well, If you have a list with set of columns and customization in SharePoint Online, You can reuse it in any other site collections without re-creating the list again from the scratch. A list template contains fields, formulas, formatting, and optionally data as well. List Templates can be downloaded and uploaded to another sites. Here is how to use list template SharePoint Online: SharePoint Online List Template Gallery URL List template gallery in SharePoint Online URL: https://yourdomain.sharepoint.com/_catalogs/lt/Forms/AllItems.aspx How to Import a List Template in SharePoint Online? List templates (.STP) downloaded, should be uploaded to any site collection's list template gallery in order to re-use. Here is how to upload a list template to SharePoint Online. Go to Settings >> Site settings page >> Click on "List templates"
Requirement: Format Calculated Column markup as Hyperlink. How to Format Calculated Column as Link using HTML Markup? Using calculated column formulas to frame hyperlink and setting the column type to "Number" renders the column markup as HTML. E.g. I've used this formula to link project documents with Projects list. =CONCATENATE("<a href='https://crescent.sharepoint.com/sites/projects/documents/'",[ProjectID],">",[Project Name],"</a>") Well, not anymore in SharePoint Online as per the Microsoft announcement Handling HTML markup in SharePoint calculated fields . SharePoint Online renders HTML markup as text instead of HTML! So, How to render Calculated column as HTML markups in SharePoint Online? Here is how: Make sure the list is in New experience, Format the calculated column Use this JSON to format the column markup as HTML. { "$schema": "https://developer.microsoft.com/json-schema
Requirement: A SharePoint Online team site (Classic / Modern Experience) users wants to transform their existing site to Office 365 group to take advantage of Office 365 Group offerings such as Shared mailbox, Planner, Teams, etc. How to Connect to New Office 365 Group in SharePoint Online? When you create a new Office 365 group, there will be an associated SharePoint Team site is created automatically. In this case, we need a new Group with an existing team site. To start with, make sure connect to Office Group is enabled at tenant level. Login to SharePoint Online Admin Center >> Click on Settings from left navigation In settings page, under "Connections from sites to Office 365 groups", Set "Allow site collection administrators to connect sites to new Office 365 groups". Not all site templates can be associated with Groups (Not supported: BICENTERSITE#0, BLANKINTERNET#0, ENTERWIKI#0, SRCHCEN#0, SRCHCENTERLITE#0, POINTPUBLISHINGHUB#0, POINTPUBL
Requirement: PowerShell to Get OneDrive URL in SharePoint Online How to Get OneDrive URL of a User? Typically, OneDrive sites are located at the URL: https:// tenant -my.sharepoint.com/personal/ upn (E.g. https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com), To get a SharePoint Online user's OneDrive site, follow these steps: Login to SharePoint Online Admin Center Click on "User Profiles" link from left navigation >> Click on "Manage User Profiles" link under "People" group Search and pick the user profile which you want to gain access. From the search result, Click on the menu item "Manage Personal Site" from the context menu. This takes you to the OneDrive site! SharePoint Online: PowerShell to Get OneDrive URL Let's query user profile to retrieve Personal site URL. Remember to set the user name and admin site URL parameters prior running the script. #Load SharePoint CSOM Assemblies Add-Type
Requirement: Grant permission to all sub-folders in a SharePoint Online document library SharePoint Online: Grant Permission to Folders using PowerShell Here is the PowerShell to add a user to each folder in SharePoint Online list or document library. #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" #Set Config Variables $SiteURL = "https://crescent.sharepoint.com/sites/marketing" $ListName = "Documents" $UserAccount = "Salaudeen@crescent.com" $PermissionLevel= "Contribute" #Function To call a non-generic Load Method Function Invoke-LoadMethod() { Param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide a Client Object"), [stri
Requirement: Cascading drop-down list in SharePoint Online. How to Implement Cascading Lookup in SharePoint Online List Forms? Before implementing cascading drop down in SharePoint Online lists, we need lists with data for lookup. In my case, I've three custom lists in my SharePoint Online site. Namely: Region, Country and Project Tasks. I need cascading lookup from Regions to Country drop-down in my Project Tasks list. List 1: Region Region list has a single column "Title" with list of regions in it. List 2: Country Country list has "Title" column which holds the value of the country and "Region" lookup column from "Region" list. List 3: Project Tasks Where the "Region" lookup column is from "Region" list and "Country" Lookup column is from "Country" List. Step 1: Download jQuery and SPServices JavaScript Files and upload to SharePoint I've used compressed version of jQuer
Co-Authoring is available in Microsoft Teams on documents stored, to enable multiple people to work on the same document at the same time. Documents stored in your teams are accessible to every member of the Team. Team members can collaboratively co-author documents. How to Co-Author a Document in Microsoft Teams? To Co-Author a document, you can open it and click on Edit button and then choose any of these three options: Edit in Teams, Open in Desktop App, or Open in Browser. No need to check files out or worry about if one of your colleagues has the document open. Just open the file you need to edit and if other Team members are editing it too your changes will be seamlessly merged as you work. Microsoft Teams gives indication if any other user opened the document and making changes. Invite Users to Co-Author To share a document with additional users, you'll have to open the file in Office Web Apps or in Office desktop client. The Teams editor doesn't have that f
Requirement: Add new property to advanced search drop-down in SharePoint Online. SharePoint Online: How to Add a Property to Advanced Search Drop Down? To perform search queries based on a specific column value in SharePoint, we can use "Advanced Search". By default, you can search against any managed property such as "Author:Some Name" in SharePoint. SharePoint Online advanced search properties drop-down with default values such as "Created by", "Name","Size", etc. To add your custom column to this drop down, follow below steps: Step 1: Get the Managed Property to add to advanced search properties We need the metadata column created as managed property in order to list it in advanced search page properties drop-down. Unlike SharePoint On-premises, SharePoint Online automatically creates managed property for Site Columns during crawling, if the column has values in it! Edit the automatically created managed property to map a
Requirement: Change width of all columns in list edit form! How to modify column width in SharePoint Online? If you want to set width of a specific field in list form, find its title or ID using Developer tools and use this script in Script editor: <script> $(document).ready(function(){ $('input[title="IC Number"]').css('width','350px'); }); </script> Here is the CSS to set width of all columns: <style type="text/css"> .ms-formtable .ms-input, .ms-formtable Input { width: 250px !important; } .ms-formtable Select { width: 262px !important; } </style> Copy-paste this CSS in either Script editor or content editor web parts. Before After: If you want to modify column width in SharePoint Online list views, use: SharePoint Online: Set Column Width in List View
Requirement: Format Column in SharePoint Online using PowerShell How to Apply Conditional Formatting in SharePoint Online Column using PowerShell? Formatting columns in SharePoint Online is explained in my another post: Format Column in SharePoint Online , Here is the PowerShell CSOM script to set column format 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" #Set Variables $SiteURL = "https://abraaj.sharepoint.com/sites/marketing" $ListName="Config" $FieldName="Status" #Internal Name $JsonFormat = @" { "`$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div",
Requirement: Get all groups with "Full Control" permissions in SharePoint Online sites. Get All Groups with "Full Control" from a Site Collection Let's get all groups with full control permissions from a given site collections. #Set Parameters $AdminCenterURL="https://crescent-admin.sharepoint.com" $SiteUrl = "https://crescent.sharepoint.com/sites/oncology" #Connect to SharePoint Online Connect-SPOService -Url $AdminCenterURL -credential (Get-Credential) #Get all Groups from the site $SiteGroups = Get-SPOSiteGroup -Site $siteURL #Get Group info that have "Full Control" Permissions ForEach ($Group in $SiteGroups) { If($Group.Roles.Contains("Full Control")) { Write-Host -f Yellow $Group.Title #Get each member of the group ForEach($User in $Group.Users | Where{$_.contains("@")}) #Exclude system Users { write-host -f Green $User } } } PowerShe
What is Calendar Overlay in SharePoint Online? Calendar overlay is a cool feature in SharePoint that lets you to layer the contents of multiple calendars into a single easy-to-read, color-coded calendar view. Use it when you are managing more than one calendar in your SharePoint environment but want to create a consolidated view of all events across these calendars. For example, you may have a calendar for your Team and a calendar for your organization. You can combine them and view all events from both calendars (technically up to 10 calendars) in a single view. In short: Calendar Overlay feature in SharePoint Online aggregates events from Multiple Calendars in a Single View How to Add Calendar Overlay in SharePoint Online? To configure a calendar overlay, do the following: Navigate to the calendar list on top of which you want to overlay other calendar events. On the calendar view page, Click on the Calendar ribbon tab >> Click on "Calendars Overlay" button.
Requirement: Grant Permission to a User on All Items in a SharePoint Online List PowerShell to Grant Permissions to a User on All Items in a List 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/marketing" $ListName= "Migration Documents" $UserAccount = "i:0#.f|membership|salaudeen@crescent.com" $PermissionLevel = "Edit" #To call a non-generic method Load Function Invoke-LoadMethod() { param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide a Client Object"), [string]$PropertyName ) $ctx = $Object.Context
Requirement: Create a Quick Access Link to SharePoint in Windows Explorer. How to Pin SharePoint Document Library to Quick Access in Windows Explorer? Being able to access SharePoint document libraries from windows explorer helps us to save a lot of time, especially when you want to save or open files quickly! We can add frequently accessed document libraries to "Quick Access" (known as "Favorites" in earlier versions of Windows such as "Windows 7"). Follow these steps to add SharePoint document library to add to Quick Access: Open your SharePoint Online document library in Internet Explorer From the "Views" drop-down, Click on "View in File Explorer" option. This opens the document library in Explorer view. Copy the location URL from the Address bar. Right click the "Quick Access" on the file explorer and choose "Pin current folder to Quick Access". That's all! Now, You'll find a handy shortcut
Requirement: Remove user from office 365 group using PowerShell How to Remove a User from Office 365 Group? As an admin, you can remove members from any Office 365 group through Microsoft 365 admin center. Here is how: Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on Groups link in the left navigation. Search and Select the Office 365 group you wish to remove members. In the Group details page, Click on "Members" tab >> Click on View all and manage members link. Now you can remove group members by clicking on the "X" button next to each member. Hit save once you are done! PowerShell to Remove User from Office 365 Group Here is how we can use PowerShell to remove a user a office 365 group: #Variables $GroupName = "IT Team" $UserUPN = "salaudeen@crescent.com" #Connect to AzureAD Connect-AzureAD -Credential (Get-Credential) #Get the Azure AD Group $AADGroup = Get-Azur
Requirement: Remove user from all groups in a SharePoint Online Site Collection SharePoint Online: PowerShell to Remove User from All Groups This PowerShell script gets all groups of the given user and removes from the group. #Set Parameters $AdminCenterURL="https://crescent-admin.sharepoint.com" $SiteUrl = "https://crescent.sharepoint.com/sites/marketing" $UserLoginID = "i:0#.f|membership|salaudeen@crescent.com" #Connect to SharePoint Online Connect-SPOService -Url $AdminCenterURL -credential (Get-Credential) #Get All Groups of the User $UserGroups = Get-SPOUser -LoginName $UserLoginID -Site $SiteURL | Select -ExpandProperty Groups #Remove User from all Groups $UserGroups | ForEach-Object { Remove-SPOUser -Group $_ -Site $SiteUrl -LoginName $UserLoginID} Run this script in SharePoint Online Management Shell. Remove User from All Groups using PowerShell CSOM #Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Mi
Requirement: Remove user from all items in a list SharePoint Online: Remove User Permissions from All Items using PowerShell There are multiple items with unique permissions in a SharePoint Online list where a specific user is granted access. There is a requirement to remove the particular user from all list items where he has access. Here is the PowerShell for SharePoint Online to remove item level permissions : #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/marketing" $ListName= "Migration Documents" $UserAccount = "i:0#.f|membership|salaudeen@crescent.com" #To call a non-generic method Load Function Invoke-
Requirement: Grant Permission to All Files in a Folder in SharePoint Online PowerShell to Set Permission to each File in a Folder: #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" #To call non-generic method Load(list, x => x.HasUniqueRoleAssignments) Function Invoke-LoadMethod() { param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide a Client Object"), [string]$PropertyName ) $ctx = $Object.Context $load = [Microsoft.SharePoint.Client.ClientContext].GetMethod("Load") $type = $Object.GetType() $clientLoad = $load.MakeGenericMethod($type) $Parameter = [System.Linq.Expressions.Expression]::Parameter(($type), $type.Na
Requirement: Update Permission Level in SharePoint Online SharePoint Online: How to Edit a Permission Level? We have had a permission level "Contribute without delete" which allows users to add/edit items but not delete. Now, we got a new requirement to exclude edit also from the permission level so that it prevents users from editing list items, even their own! So how to change the permission level in SharePoint? To edit an existing permission level in SharePoint Online, follow these steps: Navigate to SharePoint Online Site collection where you want the permission level to be edited. Click on Settings gear >> Select Site Settings from the Settings menu. On the Site Settings page, Click on "Site Permissions" link under Users and Permissions section. On the Permissions page, Click on "Permission Levels" button from the Permissions tab of the ribbon. In Permission Levels page, Click on the permission level you want to edit. Uncheck t
Requirement : Get All AD Security Groups in a SharePoint Online Site. CSOM PowerShell to Find All AD Groups in SharePoint Online: Here is the PowerShell to get all active directory domain groups from SharePoint Online site collection: #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" #Set Variables for Site URL $SiteURL= "https://crescent.sharepoint.com/sites/marketing/" $ADGroupCollection= @() #Setup Credentials to connect $Cred = Get-Credential Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password) #Get all Users $Users=$Ctx.W
Reviewed by Salaudeen Rajack
on
January 30, 2019
Rating:
