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

  • Adam_636382
    Adam_636382 Posts: 32
    Answer ✓

    Found the answer to my own question: you can use Field Formulas to identify the document ID after the look up step:

Answers

  • Sean_510793
    Sean_510793 Posts: 69 admin

    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
    JavaScript
    result = fields["quickchart-api--response--body--file"]
    Return field name
    chart-id

    Field: Field Formulas
    JavaScript
    result = "https://_YOURTEAMNAME_.pushbot.com/_/teams/_YOURTEAMNAME_/files/{{chart-id}}/download"
    Return field name
    chart-uri

    Assign Task to a person
    Instructions
    ![]({{chart-uri}})