I want clickable Hyperlink in My Excel

(0) Share

Report

Posted on by CU21050605-0

Hello,

below is a screen shot of a Power Automate flow, that get items form SharePoint list, and send it as an excel file as attachment via email.

i would like to make the "Titel" to be clickable Hyperlink, so the receiver can click on it and see the item details in SharePoint.

i tried below function in "Select", but it is not working with "Http Request "

concat(
  '=HYPERLINK("',
  item()?['{Link}'],
  '","',
  item()?['Title'],
  '")'
)

2.jpg

1.jpg

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Youssef_Arouay 200 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Try using the SharePoint item URL manually like this instead:

concat( '=HYPERLINK("https://YOURTENANT.sharepoint.com/sites/YOURSITE/Lists/YOURLIST/DispForm.aspx?ID=', string(item()?['ID']), '","', item()?['Title'], '")' )

Was this reply helpful? Yes No
chiaraalina 2,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

Why are you using the Office 365 Users Connector to update the Excel? Does it work with your select and normal values?

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU21050605-0 this worked for me:

{

"values": [

[

"=HYPERLINK(\"item()['Link']\",\"item('Title')\")"

]

]

}

Was this reply helpful? Yes No
CU21050605-0 4 on at

Like (0)

Report
Copy link

Link copied!

@Youssef_Arouay Thank you for the suggestion ,
Select formate accepted the formula but the "Http Request" took too long time and the the flow stopped !

Was this reply helpful? Yes No
CU21050605-0 4 on at

Like (0)

Report
Copy link

Link copied!

@chiaraalina Would you please show me where you placed the function? is it in Select?
i tried in select and JESON formate find it not working

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU21050605-0 I used it directly

Is that okay, can you use it like this or do you have to use the Select action?

Was this reply helpful? Yes No
CU21050605-0 4 on at

Like (0)

Report
Copy link

Link copied!

@chiaraalina
i am using the Output of the "select' and let HTTP request to make the array

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU21050605-0 ok

look this, with Select action, worked for me:

[
"@{item()?['ID']}",
"=HYPERLINK(\"@{item()?['Link']}\",\"@{item()?['Title']}\")"
]

Let me know if it worked!

Was this reply helpful? Yes No