Turn link into hyperlink

%3CLINGO-SUB%20id%3D%22lingo-sub-2897060%22%20slang%3D%22en-US%22%3ETurn%20link%20into%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2897060%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20take%20a%20field%20from%20a%20workbook%20and%20turn%20it%20into%20a%20hyperlink%20field%3F%20%26nbsp%3BFor%20example%20my%20query%20returns%20results%20including%20a%20field%20that%20shows%20%22%3CA%20href%3D%22https%3A%2F%2Fhost.com%2Ffiletodownload%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhost.com%2Ffiletodownload%3C%2FA%3E%22.%20%26nbsp%3BWhat%20I'd%20like%20it%20the%20ability%20to%20click%20on%20that%20link%20from%20the%20workbook%20and%20download%20the%20file.%20%26nbsp%3BPossible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2897458%22%20slang%3D%22en-US%22%3ERe%3A%20Turn%20link%20into%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2897458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1080673%22%20target%3D%22_blank%22%3E%40j0ebeer%3C%2FA%3E%26nbsp%3BYou%20can%20setup%20a%20parameter%20(Use%20the%20%22Add%20parameters%22%20option%20when%20adding%20a%20new%20step)%20that%20can%20run%20your%20query%20and%20save%20the%20output.%26nbsp%3B%20Then%20you%20can%20use%20that%20parameter%20in%20a%20Link%20field%20(Use%20the%20%22Add%20Links%2FTabs%22%20option%20when%20adding%20a%20new%20step)%20which%20allows%20you%20to%20perform%20different%20actions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2901410%22%20slang%3D%22en-US%22%3ERe%3A%20Turn%20link%20into%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2901410%22%20slang%3D%22en-US%22%3EFound%20what%20I%20needed.%20In%20the%20Column%20settings%20I%20found%20where%20I%20can%20specific%20the%20column%20as%20a%20Link%20with%20a%20URL.%20Works%20perfectly.%3C%2FLINGO-BODY%3E
Occasional Contributor

Is it possible to take a field from a workbook and turn it into a hyperlink field?  For example my query returns results including a field that shows "https://host.com/filetodownload".  What I'd like it the ability to click on that link from the workbook and download the file.  Possible?

2 Replies

@j0ebeer You can setup a parameter (Use the "Add parameters" option when adding a new step) that can run your query and save the output.  Then you can use that parameter in a Link field (Use the "Add Links/Tabs" option when adding a new step) which allows you to perform different actions.

Found what I needed. In the Column settings I found where I can specific the column as a Link with a URL. Works perfectly.