Quick Answer for Broken List Links

To restore functionality, remove any custom JSON or conditional formatting applied directly to the hyperlink column. If you need visual styling, apply the formatting to a separate text or status column, or use View-level formatting instead.

Likely Causes Behind Non-Clickable SharePoint URLs

• JSON Overrides: Custom JSON scripts often replace standard HTML elements, accidentally stripping out the necessary anchor tag required for hyperlinks.
• Z-Index Layering Issues: Background colors or pill shapes applied via conditional formatting can place a styled container over the text, blocking mouse clicks from reaching the underlying link.
• Improper Column Type: Attempting to format a "Single line of text" column as a hyperlink using JSON without properly specifying the defaultHoverField or anchor attributes.

Recommended Solution: Restoring Clickable Anchor Tags

1. Navigate to your Microsoft List or SharePoint list in your web browser.
2. Locate the unclickable hyperlink column and click on the Column Header (the title of the column).
3. From the dropdown menu, hover over Column settings and select Format this column.
4. A formatting pane will appear on the right side of the screen. If you are using standard conditional formatting, click Clear formatting or uncheck the rules.
5. If you are using custom code, click Advanced mode at the bottom of the pane, delete all the JSON code in the editor, and click Save.
6. Refresh the web page. Your links should now be fully clickable and functioning normally.

Alternative Solutions for Safe Column Styling

1. Apply Formatting to a Sibling Column: Leave your Hyperlink column completely unformatted so it remains functional. Instead, apply your JSON or conditional color-coding to a nearby "Status" or "Category" column to achieve the desired visual impact.
2. Use View Formatting: Instead of formatting a single column, format the entire Row. Click the View dropdown (e.g., "All Items") in the top right > Format current view > Conditional formatting. This applies background colors to the whole row without breaking individual column mechanics.
3. Re-code the JSON (Advanced): If you must format the hyperlink column, ensure your custom JSON explicitly includes an "elmType": "a" attribute and assigns the URL data to the "href" property properly.

Working with WPS Office: Handling Data Locally

While WPS Office cannot directly alter web-based SharePoint or Microsoft Lists configurations, it serves as an excellent alternative if you prefer managing hyperlinked datasets offline. By exporting your Microsoft List to a CSV or Excel file, you can open it in WPS Spreadsheet. WPS Office provides a highly compatible, free environment for sorting, styling, and managing hyperlinked data natively—without the headache of complex JSON web formatting breaking your links.

Prevention Tips for List Formatting Errors

• Test on a Dummy Column: Before deploying complex JSON code to critical URL columns, test it on a temporary test column.
• Keep URLs Plain: Adopt a team-wide best practice of leaving Hyperlink/Picture columns unformatted to ensure maximum compatibility across different devices and browsers.
• Backup JSON Code: If you are modifying complex list formatting, copy and paste the working JSON code into a text editor before making changes so you can easily revert if the links break.

FAQs About Microsoft Lists URL Columns