Fix Invalid URL Errors for Mailto Links in SharePoint Lists
Question details
Users need a way to insert clickable email links into a SharePoint list without triggering an invalid URL validation error.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Creating or editing a list item that requires a clickable email address link for quick communication.
- Observed behavior
- SharePoint rejects the 'mailto:email@example.com' string when entered directly into a hyperlink column, displaying an 'Invalid URL' error upon saving.
Ensure you have the necessary list editing permissions to modify column settings and apply custom JSON formatting in your SharePoint environment.
Use JSON Column Formatting to Generate Mailto Links
Instead of using a default Hyperlink column, store the plain email address in a text column and use JSON formatting to convert it into a clickable mailto link.
SharePoint's default hyperlink columns strictly validate URLs and expect standard web protocols like HTTP or HTTPS. By storing just the email address in a standard text field and applying JSON column formatting, you can bypass this validation while still providing users with a functional email link.
Add a new column to your SharePoint list and set the type to 'Single line of text'. Store only the raw email address (e.g., email@example.com) in this field without the 'mailto:' prefix.
Click on the header of your newly created text column, select 'Column settings' from the drop-down menu, and click 'Format this column'.
In the formatting pane that appears on the right side of the screen, click on 'Advanced mode' at the bottom to allow custom JSON input.
Paste a JSON schema that creates an anchor element (`<a>`). Set the `href` attribute to concatenate the string 'mailto:' with your column's current field value (`[$YourColumnName]`).
Click 'Save' at the bottom of the pane. Test the column by clicking the generated email link in a list item to ensure it successfully launches your default email client.
Looking for a Lightweight Office Suite? Try WPS Office
While SharePoint handles your team's lists and intranet pages, you still need a reliable suite for document creation. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for all your daily word processing, spreadsheet, and presentation needs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for Windows, Mac, or Linux.
- 2. Install WPS Office: Run the downloaded installation package and follow the brief on-screen instructions.
- 3. Open Your Files: Launch WPS Office to easily open, edit, and save your existing Word, Excel, and PowerPoint documents.
Frequently Asked Questions
Why does SharePoint reject mailto links in the hyperlink column?
SharePoint's default hyperlink column expects a standard web protocol such as http:// or https://. It does not recognize the 'mailto:' protocol as a valid web address, resulting in the Invalid URL error.
Can I add a CC or BCC field using JSON formatting in SharePoint?
Yes, you can modify the JSON formatting's href property to include '&cc=email@example.com' or '&bcc=email@example.com' immediately following the subject parameter to auto-populate these fields in the email client.
Do I need administrative privileges to apply JSON formatting?
You typically need at least 'Edit' or 'Design' permissions on the SharePoint list to access the Column settings and apply custom JSON formatting rules.
