Creating a Link from Form Data

[Redcadence]

Hello,

I have a flow that is working really well.  It takes data from Microsoft form submissions, adds it to an existing Excel table and sends an email to a shared mailbox.  Part of the form collects links to various SharePoints, and I would like for this to show as a link in the table, rather than as text.  I can't get my head around how to make this happen. The two sections looped in green are the sections that contain the SharePoint addresses. 

[srApps · Accepted solution]

You could do something like this by adding some text to the fields which is an Excel function.

=HYPERLINK("DynamicContent", "DynamicContent")

[Redcadence]

Thank you, this is just what I need.