Question1 : I' d like to post a "site address”(an answer of Forms) in a row of Column "related Address" in Excel table. But the string of related Address is verylong, so to post the string "link" (hyperlink) and if click "link", transit to real site address.
Question2: When we obtain a page link from OneNote and enter it into the "related Address" field in Forms, the site address is transferred to Excel, but it does not become a hyperlink when clicked.
Question3: When the site address is transferred to the site address column in Excel, how can it be hyperlinked without clicking once?"
To add a hyperlink to an Excel table via Power Automate, you will need to work with an Office Script. This is an automation feature from Excel 365, where you can create custom scripts in TypeScript to perform regular tasks, similarly to what VBA does for Excel on Desktop.
Since not all 365 licenses has Office Scripts enabled, please confirm if you have this Automate tab in your Excel:
If you have it enabled, I can help you to build a script for adding a hyperlink to any specific field in your table record.
You can also find more information on what is and how to work with Office Scripts in the following articles:
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
