How to Add Help Desk Contact to Office 365 Help Menu?

December 14, 2018    ,
How to Add Your Help Desk Contact Information to Help Pane in Office 365? Adding your help desk contact information to the help pane in Office 365 - SharePoint Online helps users to quickly access your help desk. Here is how to add custom help desk info: Sign in to Office 365Admin Center as a Global Admin >> In the Office 365 admin center, Click on Settings >> Organization profile Click on Edit Button next to Provide customized help desk contact info Turn ON Help desk card Provide data for fields which you want to display on Card and Click on Save These changes reflect from next time users sign in. You'll find the custom help desk contact details in SharePoint Online, Exchange, etc.
How to Add Help Desk Contact to Office 365 Help Menu? How to Add Help Desk Contact to Office 365 Help Menu? Reviewed by Salaudeen Rajack on December 14, 2018 Rating: 5

SharePoint Online: Disable Page Comments in Modern Sites using PowerShell

November 14, 2018    , ,
Requirement: Disable page comments in SharePoint Online Modern Sites and Communication sites. How to Disable Page Comments in SharePoint Online? Modern pages in SharePoint Online have a comments section at the bottom of each page for better collaboration. Option 1: Disable Comments at the tenant level Page comments can be turned-off at tenant level by the below settings: Navigate to SharePoint Online Admin Center: https://yourdomain-admin.sharepoint.com   Click on Settings from left navigation On the Settings page, Select "Disable Comments on Site Pages." Click OK to save your changes. Wait for a while, the comments section disabled from all pages in the tenant. Option 2: Disable Comments at the Page Level   Comments can be disabled at page level. Here is how: Navigate to the SharePoint Online Site page >>  Edit the page. Turn off the comments by toggle the switch from ON to OFF position and Publish the page. This disables comments section in t
SharePoint Online: Disable Page Comments in Modern Sites using PowerShell SharePoint Online: Disable Page Comments in Modern Sites using PowerShell Reviewed by Salaudeen Rajack on November 14, 2018 Rating: 5

SharePoint Online: Find All Large Files using PowerShell

November 12, 2018    , , ,
Requirement: Find all large files in SharePoint Online site collection. How to Find Large Files in SharePoint Online? To find large files in SharePoint Online, you can use "Storage Metrics" page. Navigate to your SharePoint Online site collection >> Click on Settings Gear >> Site Settings In Site Settings page, Click on "Storage Metrics" link under "Site Collection Administration" (https://crescent.sharepoint.com/_layouts/15/storman.aspx) The Storage Metrics page gives you the current Storage consumption of the site. You can navigate to each site/folder objects to get the storage stats of the particular object. You can also include the OOTB "File Size" column in your document library views to get the size of individual files! Explorer view also helps!! SharePoint Online: PowerShell to Get All Large Files in a Site Collection Getting large files by navigating into each folder from the above Storage metrics page is cumb
SharePoint Online: Find All Large Files using PowerShell SharePoint Online: Find All Large Files using PowerShell Reviewed by Salaudeen Rajack on November 12, 2018 Rating: 5

SharePoint Online: How to Apply Column Formatting?

November 09, 2018    ,
Column Formatting in SharePoint Online Column formatting in SharePoint Online modern lists and libraries customizes the field's appearance based on its value. In the past, We used SharePoint Designer and jQuery-CSS methods to format columns. But now in SharePoint Online we can apply formatting to columns with JSON. How to Apply Column Formatting in SharePoint Online List? Column formatting in SharePoint Online Choice, Yes/No, Date columns can be applied with few clicks without even JSON knowledge. Here is how we can use column formatting in SharePoint Online list: To apply formatting on a column in SharePoint Online list or library, Click on a column header, select Column settings from the menu, and then click Format this column .  The Format column panel will open. Click on "Edit Template" link Since this is a choice column, SharePoint displays a a list of all choices with a little color palette icon. Select colors for different choice values and click on app
SharePoint Online: How to Apply Column Formatting? SharePoint Online: How to Apply Column Formatting? Reviewed by Salaudeen Rajack on November 09, 2018 Rating: 5

SharePoint Online: Update Content Type using PowerShell

October 14, 2018    , , ,
Requirement: Update content type settings in SharePoint Online using PowerShell How to Update Content Type Settings in SharePoint Online? To editing content type's general settings such as name, description, and group information, follow these steps: Navigate to the SharePoint Online site where the content type was created. Click on Settings >> Site Settings On the Site Settings page, Click on "Site Content Types" link under "Web Designer Galleries" section. On the Site Content Types page, click the name of the content type to be edited. On the edit page, click the "Name,Description, and Group" link in the Settings section. On the Content Type Settings page, You can update the Name, Description, and Group information as necessary.  Click OK button to save your changes. SharePoint Online: Update Content Type using PowerShell Lets update content type name, description and group using PowerShell #Load SharePoint CSOM Assemblies Ad
SharePoint Online: Update Content Type using PowerShell SharePoint Online: Update Content Type using PowerShell Reviewed by Salaudeen Rajack on October 14, 2018 Rating: 5

SharePoint Online: Site Collection Permissions Report using PowerShell

September 06, 2018    , , , ,
Requirement: Generate permissions report for a SharePoint Online site collection. SharePoint Online: Site Collection Permissions Report using PowerShell This PowerShell script generates permission report on all objects which has unique permissions on the given site collection. It scans through following securables: Site collection administrators group Given site collection and sub-sites with unique permissions All lists and libraries with unique permissions All list items with unique permissions. #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 a non-generic method Load Function Invoke-LoadMethod() { param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide
SharePoint Online: Site Collection Permissions Report using PowerShell SharePoint Online: Site Collection Permissions Report using PowerShell Reviewed by Salaudeen Rajack on September 06, 2018 Rating: 5

SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell

September 04, 2018    , , , ,
Requirement:   Generate a permission report to audit a specific user's permissions in given SharePoint Online site collection, sub-sites, all its lists, libraries and list items. How to Check User Permissions in SharePoint Online? Navigate to the SharePoint Online site on which you want to check permissions. Click on Settings Gear >> Site Settings >> Click on "Site Permissions" link. On the Site permissions page, under Permissions tab, click "Check Permissions" icon in the top ribbon. In the User/Group field, Enter the User Name which you want to verify permissions, and click on "Check Now" button In a moment, You will see list of permissions the user has on a site. But the problem is: This method of checking user permissions shows access to one site at a time. You should repeat these steps in each site, if you want to check user access for a site collection. So lets use PowerShell to generate user permissions report for ShareP
SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell Reviewed by Salaudeen Rajack on September 04, 2018 Rating: 5

How to Configure Hub Sites in SharePoint Online: Step by Step

September 01, 2018    
What is Hub Site in SharePoint Online? Hub sites in SharePoint Online is a new way to organize related sites together into centralized portals based on organizational attributes such as project, concepts, team, department, division, region, etc. A hub site can have both modern team sites and communication sites associated under it. Hub sites provide common navigational structure, look and feel, Logo and search across associated sites. Features of Hub Sites Hub site brings consistency across sites from the top to down. When a team site or communication site is associated to a hub site, it inherits common characteristics, such as: Consistent look and feel - All sites associated, gets the branding from hub site. Logo and theme of the hub site pushed to all underlying sites. This allows you to maintain a consistent look and feel across your sites.  Common Global Navigation across all associated sites Scoped Search - If you search within the hub site, It searches for content
How to Configure Hub Sites in SharePoint Online: Step by Step How to Configure Hub Sites in SharePoint Online: Step by Step Reviewed by Salaudeen Rajack on September 01, 2018 Rating: 5

SharePoint Online: How to Enable Rating in List using PowerShell?

August 17, 2018    , , , ,
Requirement: Enable Rating in SharePoint Online List How to Enable Rating in SharePoint Online? Rating feature in SharePoint Online helps to highlight documents and list items. Rating can be enabled in SharePoint Online list and libraries to let users to see and rate items. Rating can be configured as either star ratings or as Likes. Star Ratings When a list is configured for star ratings, Every time someone rates the item or a document, the scale displays the average rating of all those who rated it. To rate an item within a list, click on the star that represents the rating you want to give the item. Once you select the rating, the item is updated to include your rating. If you rate the item again, the previous rating applied is replaced by the newly selected rating. Like Ratings Likes are similar to what you use on Facebook, Twitter, and LinkedIn, etc. When ratings type is set to "Likes", items are presented with Like button (little heart icon) which includes t
SharePoint Online: How to Enable Rating in List using PowerShell? SharePoint Online: How to Enable Rating in List using PowerShell? Reviewed by Salaudeen Rajack on August 17, 2018 Rating: 5

SharePoint Online: Export User Information List using PowerShell

August 17, 2018    , , , ,
Requirement: Export User Information List in SharePoint Online User Information List in SharePoint Online stores information about a user by having some metadata set up for the user such as User Picture, Email, DisplayName, LoginName etc. When we grant permissions to a user, they are added automatically to the hidden User Information list. SharePoint retrieves user related metadata for fields such as Created By,  Last modified, etc from the User Information List. PowerShell to Export User Information List in SharePoint Online This PowerShell script exports all user information to a CSV file from the user information list of any 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" #P
SharePoint Online: Export User Information List using PowerShell SharePoint Online: Export User Information List using PowerShell Reviewed by Salaudeen Rajack on August 17, 2018 Rating: 5

SharePoint Online: Create Document Set using PowerShell

August 16, 2018    , , ,
Requirement: Create a Document Set in SharePoint Online using PowerShell SharePoint Online: Create Document Set using PowerShell While my another post explains Creating Document Set in SharePoint Online - Step by Step , here is the PowerShell script to create document sets in SharePoint Online. This script assumes that the document sets feature is enabled, Content type for document set is created and added to the library already. #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" Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.DocumentManagement.dll" #Parameters $SiteURL="https://crescent.sharepoint.com/sites/marketing" $Docume
SharePoint Online: Create Document Set using PowerShell SharePoint Online: Create Document Set using PowerShell Reviewed by Salaudeen Rajack on August 16, 2018 Rating: 5

SharePoint Online: Create a Document Set - Step by Step

August 16, 2018    , ,
What is Document Set in SharePoint Online? As it's name indicates, document set is a set of related documents wrapped inside a special folder that allows multiple documents to be managed together and treated as if they were a single item. In other words, Document Set allows you to group documents together based on some criteria and then work with the group of documents as a single entity. A document set can have: Shared Metadata columns, Template, Information management policies, Workflow, Versions, etc. In real world example, Consider "Project Proposal" as a document set for your organization that consists of a Requirement specification Word document, Project portfolio PowerPoint presentation and Budget specification Excel spreadsheet. How to Create a Document Set in SharePoint Online? Creating document set in SharePoint Online is a Four step process: Enable "Document Sets" Feature if not enabled already Create a Content Type with metadata and docu
SharePoint Online: Create a Document Set - Step by Step SharePoint Online: Create a Document Set - Step by Step Reviewed by Salaudeen Rajack on August 16, 2018 Rating: 5

Office 365: Find All SharePoint Online Administrators using PowerShell

August 16, 2018    , ,
Requirement: Get All SharePoint Online Administrators of the Office 365 tenant. How to Check If a User is SharePoint Online Administrator in Office 365? To find if a user is SharePoint Online Administrator, do the following: Login to Office 365 Admin Center: https://admin.microsoft.com Expand Users >> Active Users Use the Search and the user. Click on the user from results grid, which opens user properties. In user properties page, under "Roles", You'll find "SharePoint Administrator" While these steps are quite simple, it would be cumbersome to go to each user's properties and check if he/she has SharePoint Administrator role, isn't it? PowerShell to Get a List of SharePoint Online Administrators This PowerShell script lists all SharePoint Administrators from Office 365 tenant. Use Azure AD PowerShell module to execute this script. #Connect to Azure AD Connect-MSOLService #Get SharePoint Online Administrators Role $RoleID = (Get-
Office 365: Find All SharePoint Online Administrators using PowerShell Office 365: Find All SharePoint Online Administrators using PowerShell Reviewed by Salaudeen Rajack on August 16, 2018 Rating: 5

SharePoint Online: Import Term Group, Term Set, Term from XML using PnP PowerShell

August 15, 2018    , , ,
Requirement: Import Term group, term set and terms data from a XML file to SharePoint Online using PnP PowerShell. XML File with Term Store Data: Here is my XML with Term store data <pnp:TermGroups xmlns:pnp="http://schemas.dev.office.com/PnP/2018/07/ProvisioningSchema"> <!-- Term Group --> <pnp:TermGroup Name="Deals Pipeline" Description=""> <pnp:TermSets> <!-- Term Set 1 --> <pnp:TermSet Name="Region" Description=""> <pnp:Terms> <pnp:Term Name="Africa" /> <pnp:Term Name="Asia" /> <pnp:Term Name="Australasia" /> <pnp:Term Name="Europe" /> <pnp:Term Name="MENA" /> <pnp:Term Name="America" /> </pnp:Terms> </pnp:TermSet> <!-- Term Set 2 --> <pnp:TermSet Name="DealStage" Description=""> <pnp:T
SharePoint Online: Import Term Group, Term Set, Term from XML using PnP PowerShell SharePoint Online: Import Term Group, Term Set, Term from XML using PnP PowerShell Reviewed by Salaudeen Rajack on August 15, 2018 Rating: 5

SharePoint Online: How to Change Task List UI to Modern Experience?

July 24, 2018    ,
Problem: Although the tenant level Settings for SharePoint Online list and libraries is set to New experience, Task lists are created with Classic experience by default. How to Change SharePoint Online Task List to Modern Experience? Task lists in SharePoint Online are created with Classic experience by default. To change its UI to new experience user interface: Go to Task List settings >> Click on "Advanced Settings" link Scroll down to the bottom, and from "List experience" section, Select "New experience" option and hit OK. This changes task list to new experience.
SharePoint Online: How to Change Task List UI to Modern Experience? SharePoint Online: How to Change Task List UI to Modern Experience? Reviewed by Salaudeen Rajack on July 24, 2018 Rating: 5

SharePoint Online: How to Enable Enterprise Keywords?

July 23, 2018    , , ,
Requirement: Add Enterprise Keywords in SharePoint Online What are Enterprise Keywords in SharePoint Online? Enterprise keyword columns helps to tag an Item in lists and libraries to make searching and finding them easier. Keywords that are entered in lists and libraries are centrally stored and synchronized in the Term store automatically. So when a keyword is added to any of the Enterprise Keywords column , It can be reused in all other lists and libraries in the tenant. It will be auto suggested when a user starts typing a similar word in any list or library. How to enable enterprise keywords in SharePoint Online? To add an enterprise keywords field to a list or library, do the following: Navigate to the list or library where you want to enable Enterprise keywords column. Go to List or Library Settings >> Click on "Enterprise Metadata and Keywords Settings" link from the settings page under "Permissions and Management" section. In the Enterprise
SharePoint Online: How to Enable Enterprise Keywords? SharePoint Online: How to Enable Enterprise Keywords? Reviewed by Salaudeen Rajack on July 23, 2018 Rating: 5

SharePoint Online: How to Remove Feedback Button?

July 18, 2018    ,
Requirement: Disable feedback button in SharePoint Online! Feedback button in bottom right of SharePoint Online gets your feedback comments to Microsoft Uservoice directly. In my case, End users thought their comments are going to the IT team of the organization and we wanted to hide feedback button in SharePoint Online to avoid the confusion. Disable Feedback Button in SharePoint Online: To remove remove feedback button in SharePoint Online, Open SharePoint Online Management Shell and run this PowerShell script. You'll be prompted for credentials.  #Set parameter values $AdminSiteURL="https://crescenttech-admin.sharepoint.com/" #Connect to SharePoint Online Admin Site Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) # Disable Feedback button Set-SPOTenant -UserVoiceForFeedbackEnabled $False This turns off feedback for SharePoint Online at tenant level. We used CSS to hide feedback button in the past. But this is the perfect way to remove
SharePoint Online: How to Remove Feedback Button? SharePoint Online: How to Remove Feedback Button? Reviewed by Salaudeen Rajack on July 18, 2018 Rating: 5

SharePoint Online: PowerShell to Remove User from All Sites

July 15, 2018    , , , ,
Requirement: Remove User from All Sites in SharePoint Online PowerShell to Remove a User from All SharePoint Online Site Collections: Please note, you must be a site collection administrator for all site collections before running this script.  #Config Parameters $AdminSiteURL="https://crescent-admin.sharepoint.com" $UserAccount = "Jacob@crescent.com" #Connect to SharePoint Online Tenant Admin Connect-SPOService -URL $AdminSiteURL -Credential (Get-Credential) #Get all Site Collections $SitesCollections = Get-SPOSite -Limit ALL #Iterate through each site collection ForEach($Site in $SitesCollections) { Write-host -f Yellow "Checking Site Collection:"$Site.URL #Get the user from site collection $User = Get-SPOUser -Limit All –Site $Site.URL | Where {$_.LoginName -eq $UserAccount} #Remove the User from site collection If($User) { #Remove the user from the site collection Remove-SPOUser -Site $Site.URL –Lo
SharePoint Online: PowerShell to Remove User from All Sites SharePoint Online: PowerShell to Remove User from All Sites Reviewed by Salaudeen Rajack on July 15, 2018 Rating: 5
Powered by Blogger.