Tuesday, August 27, 2024

Top 3 Ways to Use SharePoint Online for Advertising and Marketing

The following are three ways to use SharePoint Online for advertising and marketing:

  • Marketing Communications Site:
    • Create a dedicated Communication Site to share news, announcements, company logos, branding guidelines, approved images, etc. Such a site can be the hub for all marketing materials and key links.
  • Audience Targeting:
    • SharePoint’s audience targeting can be set so that specific content reaches the right audience. This can be useful for personalized marketing campaigns, ensuring that different user groups see the specific content tailored to their interests.
  • Add-ins and Integrations:
    • Enhance  a SharePoint site with add-ins and integrations that can transform it into a comprehensive digital workplace. Such tools can improve engagement and streamline marketing based efforts.

Sunday, August 25, 2024

Top 3 Popular SharePoint CSOM (Client-Side Object Model) Scripts

The following are three popular SharePoint CSOM (Client-Side Object Model) scripts that can help manage and automate tasks:

  1. Using Multi factor Authentication 

This script allows you to connect to a SharePoint Online site using a Multi-Factor Authentication (MFA) account. It’s useful for securely accessing a SharePoint environment.


# Install SharePoint Online Client SDK

Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Force -AllowClobber


# Connect to SharePoint Online

Connect-SPOService -Url https://yourtenant-admin.sharepoint.com


2. Provision SharePoint Sites

This script helps one set up sites with predefined configurations.


# Install PnP PowerShell

Install-Module -Name SharePointPnPPowerShellOnline -Force -AllowClobber


# Connect to SharePoint Online

Connect-PnPOnline -Url https://yourtenant.sharepoint.com -UseWebLogin


# Apply a provisioning template

Apply-PnPProvisioningTemplate -Path "template.xml"


3. Manage Permissions
This script helps when managing permissions for SharePoint Online sites, lists, and libraries. It can be utilized to grant or revoke permissions programmatically.


# Connect to SharePoint Online

Connect-PnPOnline -Url https://yourtenant.sharepoint.com -UseWebLogin


# Grant permissions

Set-PnPListItemPermission -List "Documents" -Identity 1 -User "user@domain.com" -AddRole "Contribute"

Friday, August 23, 2024

Top 3 Popular Ways to Use Power Automate in SharePoint Online

The following are the top three popular ways to use Power Automate with SharePoint Online:

  1. Approval Workflows: Automate approval processes in regard to documents and list items. For example, one can set up a flow to automatically route a document for approval when it’s added to a document library.
  2. Automated Notifications: Create flows which send notifications when specific actions occur. For example, one can notify team members when a new item is added to a SharePoint list or when a document is updated.
  3. Data Synchronization: Use Power Automate to synchronize data between SharePoint and other systems. For example, updating SharePoint lists with data from external sources or ensuring that changes in SharePoint are updated accordingly in other applications.

Wednesday, August 21, 2024

Top 3 SharePoint Online Shells

The following are the top three SharePoint Online shells that are widely used for managing and automating tasks in SharePoint environments:

  1. SharePoint Online Management Shell: This is the Windows PowerShell module with cmdlets specifically designed for managing SharePoint Online. It lets administrators perform tasks such as creating site collections, managing users, and configuring settings efficiently.
  2. PnP PowerShell: The Patterns and Practices (PnP) PowerShell module provides cmdlets which extend the capabilities of the SharePoint Online Management Shell. It is useful for complex operations and automation, such as applying site templates, managing site designs, and designating permissions.
  3. Microsoft 365 PowerShell: Such a shell is used for management across Microsoft 365 services, including SharePoint Online. It allows for the management of users, groups, and licenses, and integrates with other Microsoft 365 services.

Tuesday, August 20, 2024

Top 3 Popular Ways to Use JSON in SharePoint Online

The following are three popular ways to use JSON in SharePoint Online:

  • Customizing List Forms:
    • One can utilize JSON to customize the layout of SharePoint list forms, including the header, footer, and body sections. This lets one create a more user-friendly and visually appealing form without altering the data.
  • Column Formatting:
    • JSON can be utilized to format columns in SharePoint lists and libraries. This includes how field values are displayed, applying conditional formatting, and adding visual elements such as icons and colors.
  • View Formatting:
    • Similar to column formatting, view formatting with JSON lets one customize the entire view of a list or library. One can define how items are displayed, which includes custom styles and layouts.

Top 3 Essential Powershell Scripts for SharePoint Online

The following are three essential PowerShell scripts for managing SharePoint Online:

Connect to the SharePoint Online admin center:

$adminUser = "admin@yourdomain.com"

$orgName = "yourorgname"

$Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $adminUser

Gets all site collections in SharePoint Online:

Get-SPOSite -Limit All


Sets the site collection administrator on a given site:

Set-SPOUser -Site https://yourdomain.sharepoint.com/sites/yoursite -LoginName user@yourdomain.com -IsSiteCollectionAdmin $true

Top 3 Powerful Features of SharePoint Online

The following are the top three powerful features of SharePoint Online:

  • Create a SharePoint Team Site in Seconds: One can create group connected SharePoint team sites quickly. When one creates a group, Microsoft 365 sets up a modern team site that contains pages, lists, libraries, and team news. This allows for collaboration and communication. To create a team site:
    • If available based on one’s permissions: click the ‘Create site’ button on the SharePoint home page in Microsoft 365.
    • Them follow the wizard to set the title, group type (public or private), site classification, preferred language, and member details.
  • Customize a Site’s Look and Feel: Make the SharePoint site reflect a brand! Customize the site’s appearance by:
    • Choosing from the default SharePoint themes and modifying them.
    • Use company-approved branding themes.
    • Adjust the headers (layout, logo, background) and footers (logo, text, links,etc).
  • Multiple Top-Level SharePoint Sites: If one has a Microsoft 365 tenant (e.g., Yoursite), your top-level SharePoint site URL would be https://yoursite.sharepoint.com.