SharePoint Online
What is Recursive File Retrieval? Recursive file retrieval refers to the process of accessing and downloading all files and subfolders within a SharePoint document library or site collection in a programmatic, automated fashion. This allows for batch processing of potentially thousands of files for backup, migration, indexing, or further processing with other systems. Rather than…
The Problem: Needing to Retrieve Many Files When working with SharePoint folders that contain large numbers of files, a common task is to retrieve metadata or content for all files stored under a parent folder. However, the SharePoint REST APIs are designed for single file access and do not easily facilitate extracting details on all…
The Problem with Default Calculated Columns SharePoint’s out-of-the-box calculated columns have significant limitations when trying to carry out complex data transformations and logic: Limited Set of Functions: OOTB columns only allow a narrow set of textual, logical, and mathematical functions. Advanced operations like manipulating dates, extracting substrings, or aggregating data are not possible. No Support…
The Problem of Unstructured Email Data Email addresses contain useful identity data about users but this information is typically all contained together in a single text string that is not easily accessible for reporting and analytics. For example, an email address like [email protected] contains the username “john.doe” and the domain “contoso.com” buried within the single…
What is a Calculated Column? A calculated column in SharePoint is a column that displays a value based on a formula. The formula can reference other columns, perform operations like concatenation or rounding, call SharePoint functions, and more. Calculated columns allow displaying information derived from other data in the list or library without affecting the…
Assessing Your Current SharePoint Environment The first step in planning your migration to modern SharePoint is thoroughly evaluating your current SharePoint environment. This includes reviewing the SharePoint version, features and capabilities, integrations with other systems, and any customizations that have been implemented. Older versions of SharePoint lack the enhanced collaboration, intelligence, accessibility, and mobility offered…
Defining SharePoint Governance SharePoint governance refers to the policies, processes, roles, and metrics that ensure SharePoint environments meet organizational business needs. Effective SharePoint governance is essential for managing risk, driving adoption, and realizing ROI from SharePoint investments. Key components of a SharePoint governance model include: Executive sponsorship to provide leadership support Steering committees to set…
The Problem with Losing “this” Context When working with the SharePoint JavaScript object model (JSOM), it is common to pass callback functions to asynchronous methods to handle the response. Inside these callbacks, the meaning of “this” can change, causing errors. For example, say we make a call like: var context = new SP.ClientContext(); var web…
Understanding SharePoint Security Needs As organizations continue adopting cloud-based SharePoint platforms, they must implement robust security measures to safeguard sensitive data and documents. SharePoint contains valuable information such as financial reports, product designs, customer data and other intellectual property that cybercriminals actively target. Key security considerations when moving SharePoint to the cloud include: Managing user…
Leveraging Caching to Boost Speed Caching allows commonly accessed pages and session data to be temporarily stored, or cached, in memory for faster retrieval times. Enabling caching in SharePoint can significantly improve performance by reducing load on the database and web servers. Here are three key caching techniques to leverage: Enable output caching for commonly…