Share via

How to replace tags (div<div>div&amp;lt;div&amp;gt; and &amp;lt;/div&amp;gt;/div</div>/div) of a column in SharePoint List?

Lina Escobar 0 Reputation points
2024-06-13T12:35:19.52+00:00

Hi everybody!

At the beginning, Invoice Description column in SharePoint List was created as Multiple lines of text and Rich text. When trying to edit the column in grid view the message "This cell is read-only" is observed. In order to edit it in grid view, I changed the setting to Plain text, but as you can see in the image the words div<div>div&lt;div&gt; and &lt;/div&gt;/div</div>/div appeared, affecting the text.

How can I fix this? How would be the best solution? Could I fix it with JSON formatting? or using a flow in Power Automate? I have a total data: 66390.

I really appreciate your support.

Lina MarcelaImagen 8

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,082 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 43,331 Reputation points Microsoft Vendor
    2024-06-14T06:43:46.99+00:00

    Per my test, I have the same result with you when we select the multi-line column type as Rich text.

    And per my research I found this is by design. We can't edit the multi-line text with rich text (Bold, italics, text alignment, hyperlinks) type in datasheet view.

    As a workaround, change the type to Enhanced rich text (Rich text with pictures, tables, and hyperlinks) instead of Plain text.

    1

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.