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
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.