I Learned Another Lesson on SharePoint Multiline Text Fields

I have been struggling with a multiline text field returning HTML DIV tags in the first and last record of a collection when I point it to this particular column.

I don't remember how many times I have heard Darren say, "Make sure you select plain text when adding a text column in SharePoint."

Well today CoPilot was able to give me a correct answer for why the text was showing up wrapped in HTML. It suggested checking the column type. When I looked at the settings, there it was, plain as day.

The first record showed up with <div class="ExternalClass3EF1E2D3305044989EAF2F23DE178BF6"> where the class name changed each time I ran the app. The last record had </div> after the single digit number.

No matter how I tried using the Substitute function, the next time I opened the app for editing the class changed, and the Substitue functions did not work anymore.

2 comments