Fix SharePoint Lookup Link Opens Document Properties Page
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.
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.
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.
Navigate to your SharePoint Document Library, click on 'Add column' at the end of your column headers, and select 'Hyperlink'.
Name the column appropriately (for example, 'Direct File Link') and save your changes.
Select the document you want to link to, click the 'Copy link' button, or open the details pane to copy the direct path.
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.

Automate Hyperlink Population Using Power Automate
Use Microsoft Power Automate to automatically populate the Hyperlink column whenever a new document is created in the library.
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.

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.




