JSON Formatting not working past first 30 rows of a Sharepoint List?

Lai, Ian 20 Reputation points

I have the following column formatting for a column in my sharepoint list.


"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "a",

"txtContent": "=if(@currentField != '',[$URL],''",

"attributes": {

"target": "_self",

"href": "=if(@currentField != '',[$URL],''"



This works perfectly fine turning a multiple lines of text field into a clickable link, and I do this so that it bypasses the character limit of 255 in the link fields, as shown in this tutorial https://manueltgomes.com/microsoft/sharepoint/how-to-create-hyperlink-more-than-255-characters/

However, this suddenly stops working at row 30 for some reason. The rows after row 30 are all blank with no link either. So far, I changed the Item Limit of the view from 30 to 200, and it didn't work.

Anyone know why this happens or how to fix? Need a fix urgently.

Thank you.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,795 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
895 questions
0 comments No comments
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 20,431 Reputation points Microsoft Vendor

    Hi @Lai, Ian

    After my testing, everything works fine after line 30 if both the URL and URLDescription are entered. Please make sure that both URL and URLDescription have content.

    User's image

    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.

0 additional answers

Sort by: Most helpful