Migration to Online: HTML encode character issues with Rich Text Field

[Thanuja Seneviratne]

Hi

We are migrating a list with a richtext column which has characters like <, >. These characters includes in XML/HTML strings where those rich text column store. E.g. we have a list about email configurations where there's a column to store the body's format as html string. When the list was migrated to SharePoint Online, these characters shows like &lt; and &gt.

We use Metalogix to migrate (yet to confirm this a tool supportability issue).  Assuming this is NOT a tool's supportability issue, but SharePoint Online limitation where the rich text column cannot hold the encoded characters when it is migrated, what are the good solutions for this issue?

Workaround:- If we create a "new" rich text column and migrate the data to it and  it works fine. But if there are 100 lists (with these type of data in rich text fields) in a site, then this is not a scalable solution to  do manually. 

[#2]

Well, if a tool such as Metalogix or Sharegate does not meet your requirement, I would suggest to build your onw migration stuff based on the test you have done with the manual creation of the rich text field...you could automate this with PowerShell / .NET Code

[#3]

Thank You Juan Carlos González Martín. We actually plan to test this now on a classic site as our original migration done to a modern site. Just to confirm whether Classic vs Modern is the issue here.

We just wonder anyone else has faced the issue and the only workaround is what I listed.

--------

Thanuja