adding hyperlink of other excel sheet to output excel file

[azkh]

Hi Community!

I am stuck in my workflow where my final output file which have suppliers data with there respective groups and some other details.

I am trying to add a column name "Hyperlink" which will have a hyperlinks of the report of that particular supplier, these reports are saved in my sharepoint directory. How can I achieve this using formula tool for the hyperlink or is there any other way to get the exact report file of the supplier.
Note- The Report files on sharepoint have the Supplier Code in there file name.

I am attaching Sample Workflow

[mceleavey]

Hi @azkh ,

I tweaked the hyperlink slightly in the Report Text tool slightly, and slightly changed the grouping.

I also created a field which dynamically creates the fullpath for each file. This will now create separate reports for each supplier, with the supplier code in the name of the file.

I hope this helps,

M.