SharePoint Online: Disable Alerts using PowerShell

November 30, 2017    , , ,
Requirement: Disable Alerts in SharePoint Online! How to disable alerts in SharePoint Online? Well, there is no way to disable alerts from SharePoint Online user interface. (You can delete alerts however!). We can use PowerShell to disable alerts in a SharePoint site. PowerShell to Disable All Alerts of a User: Lets disable all alerts of a particular user in a given web - SharePoint Alerts are scoped at web object! #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" #Config Parameters $SiteURL= "https://crescent.sharepoint.com" $UserID="Salaudeen@Crescent.com" #Setup Credentials to connect $Cred = Get-Credential $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.
SharePoint Online: Disable Alerts using PowerShell SharePoint Online: Disable Alerts using PowerShell Reviewed by Salaudeen Rajack on November 30, 2017 Rating: 5

Content Editor, Script Editor Web Part Missing in SharePoint Online?

November 29, 2017    , ,
Problem: Content Editor WebPart in SharePoint Online is Missing! Fix SharePoint Online Content Editor web part missing Issue: In Modern SharePoint Online sites (E.g. Group Sites, Communication Sites), Self-serviced sites and in Root site, custom scripting is disabled by default! To enable content editor webpart and other web parts you should enable custom scripting in SharePoint Online. How to Enable Custom Scripting in SharePoint Online? To enable custom scripting at SharePoint Online Admin Center, Follow these steps: How to Enable Custom Script in SharePoint Online? This makes the content Editor web part available! Not just content editor, but also: Script Editor Web Part, Business data web part, search web part , etc. Custom Script is already enabled, But still not getting Content Editor web part and Other Web Parts? Well, if the custom script setting is already enabled in SharePoint Online Admin Center, Try running this cmdlets again to enforce Custom Script settings
Content Editor, Script Editor Web Part Missing in SharePoint Online? Content Editor, Script Editor Web Part Missing in SharePoint Online? Reviewed by Salaudeen Rajack on November 29, 2017 Rating: 5

How to Add a Custom Tile to SharePoint 2016 App Launcher?

November 28, 2017    ,
Requirement: Add new tile to App Launcher in SharePoint Online. How to Add a Custom Tile to SharePoint 2016 App Launcher? We wanted to place a new tile in SharePoint 2016 app launcher for support center site, as an end-user usability improvement. SharePoint 2016 Feature Pack 1 brought us the capability to add new tile to app launcher. Here is how you can customize SharePoint 2016 App launcher. Step 1: Enable the "Custom Tiles" feature in SharePoint 2016 with PowerShell: Use this PowerShell script to enable custom tiles feature.  Enable-SPFeature -Identity CustomTiles -Url "http://intranet.crescent.com" -Force This creates a new list "Custom Tiles" in the given web application's root site collection. Step 2: Create new Tile in "Custom Tiles" list Once the feature is activated, navigate to: http://intranet.crescent.com/Lists/Custom%20Tiles/AllItems.aspx URL and add a new entry with desired URL and image for tile for your custom t
How to Add a Custom Tile to SharePoint 2016 App Launcher? How to Add a Custom Tile to SharePoint 2016 App Launcher? Reviewed by Salaudeen Rajack on November 28, 2017 Rating: 5

SharePoint Online: Change Idle Session Timeout Settings

November 28, 2017    , , ,
Task: Set idle session timeout value for SharePoint Online. How to Set SharePoint Online Idle Session Timeout? Idle session timeout in SharePoint Online is a security mechanism which warns and sign outs the user after a period of inactivity. By default, idle session timeout settings are disabled in SharePoint Online. To set default session timeout values, use the PowerShell cmdlet: Set-SPOBrowserIdleSignOut The idle timeout settings are applicable only to web browsers - doesn't affect any clients such as OneDrive Sync client - they stay logged in as usual. SharePoint Online: Configure Idle Session Timeout using PowerShell Open SharePoint Online Management Shell and run this PowerShell script to change SharePoint online session timeout: #Set Config parameters $AdminSiteURL = "https://crescent-admin.sharepoint.com/" #Connect to SharePoint Online Tenant Admin Connect-SPOService -URL $AdminSiteURL -Credential (Get-Credential) #Get Current Idle session Time
SharePoint Online: Change Idle Session Timeout Settings SharePoint Online: Change Idle Session Timeout Settings Reviewed by Salaudeen Rajack on November 28, 2017 Rating: 5

SharePoint Online: How to Add New Custom Theme using PowerShell?

November 25, 2017    , , , ,
Requirement: Create New Theme in SharePoint Online How to create new color theme in SharePoint Online? SharePoint Online Modern sites (Teams, Communications and Hub sites) provides set of default themes (Blue, Orange, Red, Purple, Green and Gray), which you can use to quickly change the look and feel or appearance of your SharePoint Online sites. In addition, you can create new theme for a more customized experience for your users. Here are the steps to add custom theme in SharePoint Online: Step 1: Create New Color Theme in SharePoint Online Create new theme in SharePoint Online using this theme designer: https://developer.microsoft.com/en-us/fabric#/styles/themegenerator , Customize and Copy the theme output. Step 2: Add Custom Theme to SharePoint Online using PowerShell Once the theme is created using theme designer, add the theme color to SharePoint Online using PowerShell. Open SharePoint Online Management Shell, run this script: #Define the color palette $ThemePallette
SharePoint Online: How to Add New Custom Theme using PowerShell? SharePoint Online: How to Add New Custom Theme using PowerShell? Reviewed by Salaudeen Rajack on November 25, 2017 Rating: 5

Fix "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it" Error in SharePoint Online

November 24, 2017    ,
Problem: When trying to Share a document with an external user, received the error message: "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it." Root cause: External Sharing is disabled either at tenant level or site collection level! Solution: Enable External Sharing for SharePoint Online at tenant level and site collection level. Follow these steps to enable external users sharing in SharePoint Online tenant. Login to Office 365 Admin Center >> SharePoint admin center  Click on "Sharing" from left navigation >>  Set " Sharing outside your organization " to either "Allow users to invite and share with authenticated external users" or "Allow sharing to authenticated external users and using anonymous access links" Click "OK" to save your changes. External Sharing is already Enabled, Still getting thi
Fix "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it" Error in SharePoint Online Fix "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it" Error in SharePoint Online Reviewed by Salaudeen Rajack on November 24, 2017 Rating: 5

Find All Office 365 Group Sites in SharePoint Online

November 23, 2017    , , ,
Requirement: Get All Group Sites in SharePoint Online. How to find all group-connected team sites in SharePoint Online? The new SharePoint Online admin center lists all group sites and modern sites. You can login to SharePoint Online Admin Center >> Click on "Active Sites" and then look for "Primary Admin" Column which has "Group Admin" to get the list of all SharePoint Online group site collections. SharePoint Online: List Group Sites using PowerShell  Run these lines of PowerShell script in SharePoint Online Management Shell. #Set Admin Center URL $AdminCenterURL = "https://crescent-admin.sharepoint.com/" #Connect to SharePoint Online Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential) #Get All Group Sites Get-SPOSite | Where { $_.Template -like 'GROUP*'} | Select URL This gets you the list of all group sites!   Get All Group Sites in SharePoint Online and Export to CSV: Gets get a list of gro
Find All Office 365 Group Sites in SharePoint Online Find All Office 365 Group Sites in SharePoint Online Reviewed by Salaudeen Rajack on November 23, 2017 Rating: 5

SharePoint Online: Enable-Disable "Everyone" Group using PowerShell

November 18, 2017    , ,
Requirement: Disable Everyone group in SharePoint Online. "Everyone" claims in SharePoint Online consists of all users already having access to the site - This includes all accounts from the authentication provider (typically Active Directory) as well as any external accounts that are invited to the tenant. This is equivalent to the "all authenticated users" who needs to login (not anonymous users). Check if "Everyone" group is enabled or Disabled: From SharePoint Online Management Shell, Type: Get-SPOTenant to get all properties of the SharePoint Online tenant which tells us whether "Everyone" and "Everyone Except External Users" groups are hidden. "Everyone" group can be hidden from Office 365 SharePoint Online tenant people picker with the below PowerShell script. How to disable everyone Group in SharePoint Online? To disable everyone, enter the below PowerShell snippet in SharePoint Online Management Shell. #
SharePoint Online: Enable-Disable "Everyone" Group using PowerShell SharePoint Online: Enable-Disable "Everyone" Group using PowerShell Reviewed by Salaudeen Rajack on November 18, 2017 Rating: 5

SharePoint Online: Get-Set Lookup Column Values using Powershell

November 17, 2017    , , ,
Requirement: Get or Set Lookup field values in SharePoint Online using PowerShell. Scenario: We've a parent list called "Parent Projects" and child list "Project Milestones". The "Parent Project Name" field in the child list is being looked up from the parent list's "Project Name" field. Here is my PowerShell scripts to get and set lookup field values. PowerShell to Get Lookup Field Value in SharePoint Online:  To retrieve the value of lookup column in a SharePoint Online list, use this PowerShell. #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 parameter values $SiteURL="https://crescent.sharepoint.com/Sites/PMO" $ListName="Project Milestones&
SharePoint Online: Get-Set Lookup Column Values using Powershell SharePoint Online: Get-Set Lookup Column Values using Powershell Reviewed by Salaudeen Rajack on November 17, 2017 Rating: 5

SharePoint Online: Get All Alerts from a Site Collection using PowerShell

November 17, 2017    , , ,
Requirement: View all alerts in SharePoint Online site collection. How to Get all alerts of a user in SharePoint Online ? Alerts are scoped at web level in SharePoint. So, to get alerts of a user in a specific site, follow these steps: Navigate to the site >> Go to Site Settings page Click on "User alerts" link under "Site Administration" Select the user from the drop down and click on "Update" button to view all alerts. This gets you all alerts of the selected user on the current site . Now the question is: How to view all alerts of a SharePoint Online user for a entire site collection? PowerShell! PowerShell to Fetch All Alerts from SharePoint Online: Here is the SharePoint Online PowerShell to get alerts from a 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
SharePoint Online: Get All Alerts from a Site Collection using PowerShell SharePoint Online: Get All Alerts from a Site Collection using PowerShell Reviewed by Salaudeen Rajack on November 17, 2017 Rating: 5

SharePoint Online: Find All External Users using PowerShell

November 13, 2017    , ,
Requirement: SharePoint Online List External Users using PowerShell Users outside of the organizations can be invited to collaborate to SharePoint Online as "External Users". As Microsoft says: "An external user is someone outside of your organization who can access your SharePoint Online sites and documents but does not have a license for your SharePoint Online or Microsoft Office 365 subscription. External users are not employees, contractors, or onsite agents for you or your affiliates. SharePoint Online: How to Get External Users? As part of governance policies, we wanted to take control over external sharing, So I had to see how many external users are added to SharePoint Online and where. The Get-SPOExternalUser cmdlet displays a list of all external users in our Office 365 tenant. For an external user to be listed using this PowerShell cmdlet, they need to have accepted the invitation to the SharePoint Online environment, and have logged in at least on
SharePoint Online: Find All External Users using PowerShell SharePoint Online: Find All External Users using PowerShell Reviewed by Salaudeen Rajack on November 13, 2017 Rating: 5

SharePoint Online: Grant Permission to List Item using PowerShell

November 12, 2017    , , , , ,
Permissions are hierarchical in SharePoint from Top Site collection till the List Item level. When items are created in a list or library, they inherit the permissions of that list or library. However, This inheritance can be broken and permissions can be applied directly to the items. To set unique permissions on list items, you need to configure permissions on item level. Here is how: How to Grant Access to Individual List Items in SharePoint Online? Got a business requirement to grant permissions at List item level. To set explicit permissions on SharePoint online list items, we need to break the permission inheritance first (stop inheriting permissions) and then add user or group to the List Item. Go to your SharePoint Online list or library >> Select the Item to which you want to provide unique permissions.  Click on "Shared With" button from the ribbon. On the Shared With page, click Advanced. On the Permissions tab, in the Inheritance group, click Stop I
SharePoint Online: Grant Permission to List Item using PowerShell SharePoint Online: Grant Permission to List Item using PowerShell Reviewed by Salaudeen Rajack on November 12, 2017 Rating: 5

SharePoint Online: Find All Lists with Unique Permissions using PowerShell

November 12, 2017    , , , , ,
Requirement: Get All Lists and Libraries with Unique Permissions using PowerShell How to Check if a list is using Unique permissions or inheriting permissions from the parent? To get if list or library has unique permissions, follow these steps: Navigate to the list and then go to List or Library Settings. In List settings page click on "Permissions for this List/Document library" link The list settings page gives you the information whether the list has unique permissions. If the list or library has unique permissions, you'll get the text " This list/library has unique permissions ", otherwise " This list/library inherits permissions from its parent." Check If the List or Library has Unique Permissions using PowerShell:  Lets check if the given list has 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&qu
SharePoint Online: Find All Lists with Unique Permissions using PowerShell SharePoint Online: Find All Lists with Unique Permissions using PowerShell Reviewed by Salaudeen Rajack on November 12, 2017 Rating: 5

SharePoint Online: How to Hide "Create Site" Link?

November 11, 2017    
Requirement: Disable Create site link from SharePoint Online home page! The "Create Site" link in SharePoint Online Home (https://crescenttech.sharepoint.com/_layouts/15/sharepoint.aspx) helps end users to create their own modern SharePoint sites. We got a requirement to disable this "Create Site" Link as a policy decision. How to Hide the "Create Site" Link in SharePoint Online Home? To disable create site link, follow these steps: Login to SharePoint Online Admin Center (https://yourcompany-admin.sharepoint.com) Click on "Settings" in left navigation Under "Site Creation" section, select "Hide the Create site command" Click on "OK" to save your changes! This hides "Create Site" link in SharePoint Online home page for everyone including administrators (Admins can create sites via SharePoint Online Admin center or PowerShell) once you logout and login back!
SharePoint Online: How to Hide "Create Site" Link? SharePoint Online: How to Hide "Create Site" Link? Reviewed by Salaudeen Rajack on November 11, 2017 Rating: 5

SharePoint Online: How to Use CAML Query in PowerShell?

November 03, 2017    , , ,
Requirement: Use CAML Query with PowerShell in SharePoint Online CAML is an XML based query language, It stands for Collaborative Application Markup Language and used to query against items from SharePoint lists and libraries. CAM Query Elements and Operators: Here is the commonly used elements and operators in CAML queries. Operator Meaning Eq Equal To Neq Not Equal To Gt Greater Than Geq Greater Than or Equal To Lt Less Than Leq Less Than or Equal To Contains Contains IsNull Null IsNotNull Not Null BeginsWith Begins With Text In Value in any of the given values NotIn Value not in any of the given values Includes Same as Eq - In Multi-select Lookup columns, Checks if the given values ar
SharePoint Online: How to Use CAML Query in PowerShell? SharePoint Online: How to Use CAML Query in PowerShell? Reviewed by Salaudeen Rajack on November 03, 2017 Rating: 5
Powered by Blogger.