Convert all rich text fields to enhanced rich text in SharePoint 2013/2016

This script is really helpful when you are upgrading your SharePoint environment or in the scenario when InfoPath is not 100% supported in Edge browser.

All you have to do is replace "<WebApplication URL>" with the URL of the SharePoint web application you want to modify. Highly recommended to test in non-production environment.

This script will search the web application for lists that contain multiline rich text fields, and then convert those fields to enriched rich text fields. 

Note that this process will modify the field's data type and may impact any existing customizations or scripts that reference the field. It is recommended to backup your data and test the script in a non-production environment before executing it in a production environment.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
$webApp = Get-SPWebApplication "<Webapplication URL"
foreach ($site in $webApp.Sites) {
    foreach ($web in $site.AllWebs) {
        $lists = $web.Lists | Where-Object { $_.BaseTemplate -eq "GenericList" }
        foreach ($list in $lists) {
            foreach ($field in $list.Fields) {
                if ($field.TypeAsString -eq "Note" -and $field.RichText -eq $true) {
                    # Update the field type to enhanced rich text
					$Field.RichTextMode = "FullHtml"
					$Field.RichText = $True
					$field.Update()
					Write-Host "Converted rich text field '$($field.Title)' to enhanced rich text."
                }
            }
        }

        $web.Dispose()
    }

    $site.Dispose()
}


Location: Shorewood, IL 60404, USA

Comments

Post a Comment

Popular posts from this blog

InfoPath to PowerApps: Best Practices

Image
 Here are some best practices for converting InfoPath forms to PowerApps: Plan the conversion: Start by mapping out the fields and controls that are used in the InfoPath form and how they will be translated into PowerApps controls. This will help you understand the scope of the conversion and what needs to be done. Evaluate the form data: Determine where the data from the InfoPath form is stored and if it is accessible from PowerApps. If not, consider using an alternative data source that is accessible. Choose the right PowerApps control: Consider the type of data being entered and choose the appropriate control that matches the data type, such as text input, checkbox, drop-down, etc. Use custom formulas and expressions: PowerApps has a rich set of formulas and expressions that can be used to perform complex data manipulations. Utilize these to replace the InfoPath form rules and custom code. Test the conversion: Once the form has been converted, test it thoroughly to ensure that a...
Read more

Create Azure AD groups from a CSV file

Image
To create Azure AD groups from a CSV file, you can use Microsoft Graph API and the Azure AD Graph API to programmatically create groups in your Azure Active Directory tenant. Here are the steps to follow: Authenticate to Azure AD: You need to authenticate to Azure AD by acquiring a token using OAuth 2.0. Read the CSV file: Read the CSV file containing the group information into your code. Create the groups: Use the Microsoft Graph API or the Azure AD Graph API to create the groups in your Azure AD tenant. The API requires you to send an HTTP request to create a group, which includes the group name and other properties such as description and mailNickname. Import the members: You can also import the members of each group from the CSV file by sending an HTTP request to add members to a group. Note: To avoid making multiple API calls for each group, you can also batch multiple group creation and member addition requests in a single API call, if supported by the API you are using. Here...
Read more

PowerApps Governance: What to consider

Image
PowerApps governance refers to the policies, guidelines, and procedures for managing and administering PowerApps within an organization. It covers aspects such as the creation, deployment, and management of PowerApps, as well as the security and data management considerations. Some of the key components of PowerApps governance include data source management, user access and permissions, development and testing practices, and change management processes. The goal of PowerApps governance is to ensure that PowerApps are used effectively and efficiently while also protecting the organization's data and resources. Here are some steps to consider when implementing PowerApps governance: Define the Purpose: Clearly define what PowerApps will be used for within your organization and the expected outcomes. Establish Ownership: Assign a PowerApps administrator to oversee the platform and ensure compliance with governance policies. Define Security Requirements: Set up data security and privacy...
Read more