SharePoint Document Issues

How to Create a Dynamic SharePoint Link for Lists on Different Subsites

Maira Mehtab Oct 9, 2026 870 views

Question details

The user needs a way to create context-aware dynamic links that direct users to an identical list on their current SharePoint subsite, as standard calculated columns fail to provide this functionality.

Create a Dynamic SharePoint Link for Lists on Different Subsites

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Managing identical lists across multiple SharePoint subsites where users must be automatically routed to the list residing on the subsite they are currently viewing.
Observed behavior: Standard calculated columns or choice fields cannot automatically capture the subsite context, failing to link users to the list on their current subsite.

Before you start

Ensure you have Site Owner or Member permissions across the required SharePoint subsites and an active license to use Microsoft Power Automate or Power Apps in your Microsoft 365 environment.

Solution 1Recommended

Use Power Automate to Generate Context-Aware URL Links

Build a cloud flow in Power Automate that captures the current subsite context and dynamically updates a hyperlink column in your SharePoint list.

Since calculated columns evaluate data strictly at the row level without awareness of the broader site context, Power Automate bridges this gap by fetching the exact subsite URL at the moment a list item is created or modified.

Create a new automated cloud flow

Navigate to Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the trigger 'When an item is created or modified' and connect it to your SharePoint list.

Initialize a variable for the site URL

Add an 'Initialize variable' action. Set the type to String and use dynamic content to capture the 'Link to item' or 'Site Address' property from the trigger step.

Extract and format the subsite path

Use data operations (like 'Compose') with expression functions such as split() or replace() to isolate the current subsite URL and append the specific path to your destination list.

Update the list item with the dynamic link

Add an 'Update item' SharePoint action. Map the dynamically generated URL from your Compose step into a dedicated Hyperlink column on the list item.

Use Power Automate to Generate Context-Aware URL Links

Test Across Subsites: Always test your Power Automate flow by creating items in at least two different subsites to verify that the generated URLs correctly route to the respective subsite lists.

Solution 2

Build a Contextual Navigation Interface via Power Apps

Customize your list forms or build a standalone canvas app that uses contextual parameters to direct users to the right subsite list.

Free Microsoft Office alternative

Need a Lightweight Alternative for Document Management? Try WPS Office

While Microsoft SharePoint and Power Platform are powerful for complex site topologies and automated list routing, everyday document creation requires a fast, reliable, and lightweight productivity suite. WPS Office offers a free, robust alternative to Microsoft Office, making it easy to create, edit, and share files seamlessly.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
3. Open and edit your files: Launch WPS Office and open your existing Microsoft Office documents. Enjoy full formatting retention and a seamless editing experience.

Full compatibility with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Familiar user interface requiring zero learning curve for easy migration.Lightweight installation and incredibly fast startup times.All-in-one tabbed workspace to manage documents, spreadsheets, and PDFs simultaneously.Free built-in PDF editing, conversion, and annotation tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't a standard calculated column work for dynamic subsite links?

Calculated columns in SharePoint are designed to evaluate data strictly at the individual row level within a specific list. They cannot dynamically fetch environmental context variables, such as the current subsite URL, which is necessary to construct a context-aware link on the fly.

Can I use JSON column formatting instead of Power Automate to create a dynamic link?

Yes, in modern SharePoint, you can sometimes use JSON column formatting to build dynamic links using relative paths or the [$SiteUrl] token if it is supported in your specific list view context. However, it requires an understanding of JSON syntax and may not be universally supported across all classic and modern web parts.

How do I ensure users do not get an 'Access Denied' error when clicking the dynamic link?

Generating the correct URL is only half the solution; SharePoint permissions must also be aligned. You must ensure that the user clicking the link has at least 'Read' access to both the specific subsite and the destination list they are being dynamically routed to.

Document & File Issues