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

Question

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.

Answer 1

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.

---

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.