Author: The SharePoint FAQs Team

Migrating Globally Reusable Workflows In Sharepoint And Keeping Associated Infopath Forms

ByThe SharePoint FAQs Team

Why Migrate Workflows? Migrating reusable workflows from one SharePoint farm to another allows organizations to improve performance, enhance capabilities, and maintain version compatibility. Improved Performance By migrating workflows to a new SharePoint farm, performance can be improved in several ways: Newer SharePoint versions incorporate faster workflow engines and infrastructure optimizations that speed up workflow processing…

Understanding Relationship Between Infopath And Sharepoint For Better Workflow Management

ByThe SharePoint FAQs Team

What is InfoPath and How It Integrates with SharePoint Microsoft InfoPath is a software application used to design, deploy, fill and submit electronic forms with a rich formatting capabilities. The filled forms can be saved, emailed or submitted to a database. InfoPath gets tightly integrated with Microsoft SharePoint allowing organizations to build customized data collection…

Reconnecting Custom Infopath Forms After Migrating Sharepoint Workflows

ByThe SharePoint FAQs Team

What Happens During Migration When migrating SharePoint workflows from one environment to another, any associated InfoPath forms can become disconnected. This occurs because the form template and submitted form data are separate entities in SharePoint. During migration, while list content and metadata is transported, the underlying associations between workflows and InfoPath form templates can be…

Custom Field Rendering As An Alternative To Sharepoint Calculated Columns

ByThe SharePoint FAQs Team

The Problem with Calculated Columns Calculated columns in SharePoint allow users to create formulas that compute values from other columns. However, they come with limitations: calculated columns can suffer from performance problems, have restricted functions, cannot reference external data sources, and provide a rigid presentation layer. Custom field rendering provides an alternative method to deliver…

Best Practices For Complex Data Manipulation In Sharepoint Calculated Columns

ByThe SharePoint FAQs Team

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…

Sharepoint Calculated Columns – Unsupported Functions And Workarounds

ByThe SharePoint FAQs Team

Unsupported Functions in SharePoint Calculated Columns SharePoint calculated columns provide a powerful way to derive values in list items and document libraries by creating formulas that operate on other columns. However, several useful functions are not supported due to restrictions in the formula engine and can lead to errors if attempted to be used. Common…

Limitations Of Calculated Columns In Sharepoint

ByThe SharePoint FAQs Team

What Are Calculated Columns A calculated column in SharePoint is a column that displays a value based on a formula. The formula can reference other columns and manipulate their values to calculate a result. Some key capabilities of calculated columns include: Performing mathematical calculations like adding, subtracting, multiplying or dividing values from other columns Concatenating…

Extracting Username And Domain From Email Fields In Sharepoint Using Calculated Columns

ByThe SharePoint FAQs Team

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…

Sharepoint List Form Customization Options

ByThe SharePoint FAQs Team

Why Customize List Forms? SharePoint list forms provide the interface for users to view, add, and edit items in a list. Out-of-the-box SharePoint list forms have limited capabilities and configurations. Customizing SharePoint list forms can provide the following benefits: Improve usability: Customized forms can improve usability by modifying the layout, adjusting required fields, setting useful…

Client-Side Vs. Server-Side Options For Sharepoint List Limits

ByThe SharePoint FAQs Team

What is the List View Threshold? The list view threshold in SharePoint refers to the maximum number of items that can be displayed in a list view before performance starts to degrade. By default, SharePoint limits list views to 5,000 items to maintain optimal performance. When the number of items in a list view exceeds…