Excel spreadsheet to SharePoint list - How to successfully transfer a column containing hyperlinks?

(0) Share

Report

Posted on by DP-06011445-0

I currently have a Power Automate flow set up which updates a SharePoint list each day if a change to a table in an Excel spreadsheet is detected. One of the columns in the Excel table contains clickable hyperlinks, although not every value in that column contains a value, i.e. some of the values are null.

The flow currently populates the hyperlink column with the text of the hyperlink (as the columns data type is set to "Text" on the SharePoint list). What I would like to do is make that link clickable on the SharePoint list. Previously I tried to set the data type of the column to hyperlink, and it appeared to have a problem with rows that have null values in the column containing hyperlinks, which is why I currently have the column data type in the SharePoint list as "Text" as I wanted to at least provide the links for users to copy and paste into their browser.

Has anyone done something like this before?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

abc 123 784 Moderator on at

Like (0)

Report

To see how Microsoft stores a hyperlink in a SharePoint list, export the List to Excel. You'll see that it's something like the following:

Link Display Text#https://www.whatever...

So, when you get the text value from Excel, then you need to write it into the SharePoint list in that expected format. I don't know if off the top of my head, anymore, but give it a shot and feel free to ask specific questions.

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

If your other method was working, and the only problem was when the Excel spreadsheet did not contain a link, you can use a coalesce expression to handle this so you don't get an error. Here is the reference to this expression Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn and here is another reference on how to handle this issue Getting errors with null fields - Power Automate | Microsoft Learn

Was this reply helpful? Yes No