How to Add Hyperlink to a File in Excel Table Using Power Automate

Like (2) Share

Report

Posted on 23 Sep 2024 18:25:59 by CU23091824-0

I have a Power Automate flow that, when a form is submitted, adds the responses to a table in an Excel file stored in SharePoint, with the option in one of those questions to attach a PDF file. That file is saved in a predefined folder with a specific name. Now, here’s my question: I would like to include the file’s location as a linked address within the initial table in the 'file' field. I thought about using the 'update table' option, but I haven’t been able to specify the line because the ID I use in the table is created with the Excel ROWS formula. Additionally, I would like the link to appear as a hyperlink, meaning you can click on it and go to the file. I’m not sure if it can have a short text that redirects to the file.

Categories:

AI Builder

All responses (1)

Answers (0)

Suggested answer

Nived_Nambiar 17,503 Super User 2025 Season 1 on 23 Sep 2024 at 19:06:52

Like (1)

Report

How to Add Hyperlink to a File in Excel Table Using Power Automate

Hi,

You can try like to add file details as hyperlink to excel table, refer below example.

This is demo form used for demonstration of flow

Now the flow should be designed like - specifically at the add a row action where we add the formula to create hyperlink for the uploaded file.

Expression used-

concat('=HYPERLINK("',first(json(outputs('Get_response_details')?['body/re85ad94de32e4566813c86f4ef19bfca']))?['link'],'","',first(json(outputs('Get_response_details')?['body/re85ad94de32e4566813c86f4ef19bfca']))?['name'],'")')

This is an example on how we can use hyperlink formula to add hyperlink to an excel table, formula may change as dynamic content for form question changes in your case.

see how excel file looks like

Hope it helps !

Mark it as solution if it resolves your query !