Find Document Download path
In my workflow, I am using the "Tables: Look up Data in a Column" action to look up a file field in a table. This is returning the actual file but I need the download path for that file instead.
How can I do this?
Best Answer
-
Found the answer to my own question: you can use Field Formulas to identify the document ID after the look up step:
1
Answers
-
Hi @Adam_636382, to build on your answer, I recently had a similar need where I wanted to embed an image file. I used three actions (although the first two could be combined)
Field: Field Formulas
JavaScriptresult = fields["quickchart-api--response--body--file"]
Return field namechart-id
Field: Field Formulas
JavaScriptresult = "https://_YOURTEAMNAME_.pushbot.com/_/teams/_YOURTEAMNAME_/files/{{chart-id}}/download"
Return field namechart-uri
Assign Task to a person
Instructions![]({{chart-uri}})
0