SharePoint - Absolute reference

The following is a SharePoint Dictionary word of the day:

Absolute reference

A reference to a set location on a sheet. An absolute reference constantly refers to the equal range, even if the formula that comprises it is moved or copied to a different location.

SharePoint - Absolute path

The following is a SharePoint dictionary word of the day:

Absolute path

A string that displays the location of a file and starts with a drive identifier and root directory or network share and ends with the applicable file name. Example: C:\Documents\Work\testexample.txt and \\netshare\Documents\Work\testexample.txt.

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.

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"

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.

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.

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.