SharePoint Document Issues

Fix SharePoint Lookup Link Opens Document Properties Page

Olivia MillerOlivia Miller Nov 4, 2026 869 views

Question details

Users need a way to make a SharePoint Lookup column link directly to a document instead of opening the document's properties page.

Product
SharePoint
Device & OS
not provided
Scenario
Clicking a link generated by a SharePoint Lookup column that connects a list item to a Document Library.
Observed behavior
The generated link opens the target document's Properties view rather than displaying the file or selecting it in its parent folder.
Before you start

Ensure you have Edit permissions for both the SharePoint list and the target Document Library, and verify your access to Microsoft Power Automate if you plan to automate the link generation.

Solution 1Recommended

Use a Hyperlink Column to Point Directly to the File

Create a custom Hyperlink column in your Document Library that links directly to the file's URL, bypassing the default lookup behavior.

Since SharePoint Lookup columns are inherently designed to link to a record's properties, the most reliable workaround is to provide a dedicated, clickable hyperlink that points to the actual file.

1
Add a new column

Navigate to your SharePoint Document Library, click on 'Add column' at the end of your column headers, and select 'Hyperlink'.

2
Configure the column

Name the column appropriately (for example, 'Direct File Link') and save your changes.

3
Copy the direct file link

Select the document you want to link to, click the 'Copy link' button, or open the details pane to copy the direct path.

4
Paste the link

Edit the properties of the document and paste the copied URL into the new Hyperlink column. Users can now click this link from the properties view to open the file directly.

Use a Hyperlink Column to Point Directly to the File
Immediate Access: This method ensures that users interacting with the item's properties view will have an immediate, clickable link that opens the document itself.
Free Microsoft Office alternative

Edit and Manage Your Documents Seamlessly with WPS Office

While SharePoint handles your team's document storage and list management, WPS Office provides a lightweight, highly compatible alternative for creating, editing, and managing your downloaded Word, Excel, and PDF files without heavy subscription costs.

Fully compatible with Microsoft Office formats including .docx, .xlsx, and .pptx.Lightweight installation with a familiar, easy-to-use tabbed interface.Built-in PDF editing tools for comprehensive document management.Free to use, making it an ideal choice for teams looking to reduce software expenses.
microsoft office alternative - wps office

Frequently Asked Questions

Why does a SharePoint Lookup column open the properties page by default?

By default, SharePoint Lookup columns are designed to link list items to the metadata (properties) of the target record to establish a relational database link, rather than acting as a direct file hyperlink.

Can I change the default behavior of the Lookup column to open the file instead?

SharePoint does not currently offer a built-in toggle to change this default behavior. The best workaround is to create a separate Hyperlink column that stores the direct URL to the document.

How do I get the direct link to a file in SharePoint?

You can get a direct link by selecting the file in your Document Library and clicking the 'Copy link' button in the top menu, or by clicking the ellipsis (...) next to the file name and choosing 'Details' to copy the path.

Will my Power Automate flow update existing documents in the library?

No, a standard 'When a file is created' trigger will only apply to new documents. For existing files, you would need to create a manual or scheduled flow to iterate through the library and update the Hyperlink column in bulk.