The Best Ways to Add Hyperlinks to SharePoint List Items Using Power Automate

I recently worked with a client who needed to add hyperlinks to SharePoint list items to make their list more interactive and user-friendly. Instead of manually adding links, they wanted an automated solution that could dynamically create hyperlinks based on specific data in the list.

In this tutorial, I will explain how to add hyperlinks to SharePoint list items using Power Automate.

Add Hyperlinks to SharePoint List Items Using Power Automate

Recently, I worked with a client who manages a SharePoint list named ‘Power Platform Training Records’ to track training sessions related to Power Platform tools like Power Apps, Power Automate, and Power BI. When employees choose the training course they want to attend, the HR team updates the list with their training details.

However, instead of manually entering the URL to the training resources (a video or document), the client wants an automated solution to populate the Training Resource Link column with a link corresponding to the selected course.

The goal is to create a Power Automate flow that will:

• Detect the selected Power Platform training course
• Generate the appropriate training resource URL
• Add the hyperlink to the Training Resource Link column

For this example, I created the SharePoint list below called Power Platform Training Records, which consists of four columns: Employee Name (Person), Training Course (Choice), Date Enrolled (Date & time), and Training Resource Link (Hyperlink).

Now follow the below steps:

1. Create an automated cloud flow. Give the flow name and select the trigger When an item is created. Also, provide the Site Address and List Name.

Here is the client’s training resources link, as shown below:

https://companyname.sharepoint.com/sites/powerautomateforbeginners/Forms/AllItems.aspx

2. Add a Compose action and provide the input below, based on the client’s details (you can also provide your details):

https://companyname.sharepoint.com/sites/@{toLower(replace(triggerBody()?['TrainingCourse/Value'],' ',''))}/Forms/AllItems.aspx

3. Then add a Send an HTTP request to SharePoint action from sharePoint Connector with the below parameter:

• Site Address: Select the SharePoint Site Address
• Method: Select “POST” as the method
• URI: Provide the below URI:

/_api/web/lists/getbytitle('List Name')/items(@{triggerBody()?['ID']})

Change the List Name to match your list names.

• Header: Use the below headers to make REST API calls to SharePoint:

Content-Type: application/json;odata=verbose
X-HTTP-Method:MERGE
IF-MATCH:*

• Body:  Provide the below JSON format:

{
    "__metadata": {
        "type": "SP.Data.List Internal NameListItem"
    },
    "Column Name": {
        "Url": "@{outputs('Compose')}"
    }
}

Change the List Internal Name and Column Name to match your list and column names.

Now, it’s time to save the flow. Click on Test -> Select Manually. Add an item to the SharePoint list.

Once the flow runs successfully, refresh the SharePoint list, and you can see the hyperlink added.

Add Hyperlinks as a Title to SharePoint List Items Using Power Automate

For this example, I created the SharePoint list below called Resources, which consists of two columns.

Now follow the below steps:

1. Create an automated cloud flow. Give the flow name and select the trigger When an item is created. Also, provide the Site Address and List Name.

2. Add an Initialize variable action, give it a name, set the type to String, and use the following expression as its value.

toLower(replace(triggerOutputs()?['body/Title'],' ',''))

This expression takes the “Title” field, removes all spaces, and then converts the text to lowercase.

3. Add a compose action and provide below input:

https://www.@{variables('varTitle')}.com/

4. Then add a Send an HTTP request to SharePoint action from sharePoint Connector with the below parameter:

• Site Address: Select the SharePoint site address
• Method: Select “POST” as the method
• URI: Provide the below URI:

/_api/web/lists/getbytitle('List Name')/items(@{triggerBody()?['ID']})

Change the List Name to match your list names.

• Header: Use the below headers to make REST API calls to SharePoint:

Content-Type: application/json;odata=verbose
X-HTTP-Method:MERGE
IF-MATCH:*

• Body:  Provide the below JSON format:

{
    "__metadata": {
        "type": "SP.Data.List Internal NameListItem"
    },
    "Column Name": {
        "Description": "@{variables('varTitle')}",
        "Url": "@{outputs('Compose')}"
    }
}

Change the List Internal Name and Column Name to match your list and column names.

Run the Flow to Add Hyperlinks to SharePoint List Items

Now, it’s time to save the flow. Click on Test -> Select Manually. Add an item to the SharePoint list.

Once the flow runs successfully, refresh the SharePoint list, and you can see the hyperlink added.

Add hyperlinks with the text Click Here to SharePoint list items using Power Automate

Imagine you have a SharePoint list where you want to display the text “Click Here” as a hyperlink instead of showing the full URL. This can make the list look cleaner and more user-friendly, especially if you have long URLs or want a consistent link label for all items.

To do this using Power Automate, follow the three steps above. Then, in the Send an HTTP request to SharePoint action, use the following JSON format in the request body to set the Resource Link column with the text ‘Click Here’:

{
    "__metadata": {
        "type": "SP.Data.List Internal NameListItem"
    },
    "Column Name": {
        "Description": "Click Here",
        "Url": "@{outputs('Compose')}"
    }
}

When you run the flow and add an item, the result will look like the screenshot below:

Conclusion

In this tutorial, I covered how to add hyperlinks to SharePoint list items using Power Automate automatically. I explained three methods: the first adds a dynamic hyperlink based on the selected training course, the second creates a hyperlink from the Title field in the list, and the third displays a clean, user-friendly “Click Here” text as the hyperlink.

Related Power Automate articles:

• Add Days to Date in Power Automate
• Add Row to Excel Table Using Power Automate
• Add Item to SharePoint List Using Power Automate
• Add Attachments to SharePoint List Items using Power Automate

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.