Others

How to Create a Dynamic SharePoint Link Based on User Attributes

Chanuka Geekiyanage Oct 23, 2026 868 views

Question details

The user needs a single SharePoint link on their homepage that automatically redirects employees to specific sites or document libraries based on their profile attributes like division, state, or union status.

How to Create a Dynamic SharePoint Link Based on User Attributes

Product: SharePoint / Power Apps
Device & OS: not provided
Scenario: Setting up an intelligent homepage navigation system for employees based on customized organizational data.
Observed behavior: The user wants to implement automatic dynamic navigation instead of manually providing multiple static links to different employee groups.

Before you start

Ensure you have the necessary administrative permissions in your Microsoft 365 environment to create SharePoint lists and build custom Power Apps.

Solution 1Recommended

Build a Dynamic Navigation App using Power Apps

Create a Power Apps application that checks the current user's profile against a SharePoint list and securely navigates them to the appropriate site.

Because standard SharePoint links are static, a custom Power Apps application acts as an intelligent router. It retrieves the logged-in user's information, references a mapping list, and redirects them to the correct destination.

Create a SharePoint mapping list

Set up a new SharePoint list that maps various user attributes (such as division, state, or payroll status) to their corresponding destination SharePoint site or document library URLs.

Create a new Power App

Open Power Apps, create a new Canvas app, and connect your newly created SharePoint mapping list as a data source.

Identify the current user

Use the User() function in Power Apps to retrieve the current employee's email or identity details when the app loads.

Filter and navigate

Use the LookUp() or Filter() formula to match the current user's identity and attributes against your SharePoint list. Then, apply the Launch() function to direct them to the matched destination URL.

Embed in the SharePoint homepage

Publish your Power App and embed it onto your SharePoint homepage using the standard Power Apps web part so it functions seamlessly as a link.

Security Notice: Never store, process, or validate user passwords within a SharePoint list. Always rely on native Microsoft identity services and standard SharePoint permissions to handle authentication and authorization securely.

Free Microsoft Office alternative

Manage Your Daily Documents Effectively with WPS Office

While SharePoint and Power Apps handle complex intranet routing, WPS Office offers a lightweight, highly compatible alternative for creating, editing, and managing your daily office documents. Enjoy a familiar interface and seamless migration without the heavy enterprise subscription costs.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formatsLightweight desktop application that runs smoothly on almost any deviceFree to use with built-in advanced PDF editing capabilitiesFamiliar user interface makes team migration seamless and rapidEasily collaborate and manage shared documents across your organization

microsoft office alternative - wps office

Frequently Asked Questions

Can I create dynamic links natively in SharePoint without using Power Apps?

SharePoint's out-of-the-box navigation features, such as Audience Targeting, allow you to show or hide specific links based on Microsoft 365 Groups or Azure AD security groups. However, if you need a single link to dynamically route users based on complex, multi-variable logic (like state or payroll status), you must use a custom solution like Power Apps.

How do I use Audience Targeting in SharePoint navigation?

To enable Audience Targeting, edit your SharePoint site navigation, toggle on the 'Enable site navigation audience targeting' option at the bottom of the pane, and then edit individual navigation links to specify which Microsoft 365 groups should be able to see them.

Is it safe to store employee attribute data in a SharePoint list for routing purposes?

Yes, it is generally safe as long as you do not store sensitive credentials like passwords. You should use standard Microsoft identity services for user authentication. Additionally, ensure your SharePoint list is configured with appropriate item-level permissions if it contains confidential HR data.

Office Quick Solutions