Generating a file from a form with a bot and adding it to a record

I feel like I am close... Just missing something I can't put my finger on.

I have created a data table, the columns are used in a form to Generate a File.
I have a column in another data table which call the file location.
But I cannot get the file to populate in the record.

Driving Cost Compare Data Table
The Form works perfect. Generates the File named:
CONCATENATE("https://drive.google.com/drive/folders/costcomparison", [Traveler],[Row ID])

Request Table
I have another column in another data table (Request Table) which I want the file to be added to when the user creates the request. The file is generated prior to creating the request.
But I don't think I am using the right formula expression.
CONCATENATE("https://drive.google.com/drive/folders/costcomparison", Driving Cost Compare[Traveler],[Row ID]) (Driving Cost Compare is the Data table used to initially create the file.)

CANAIT_0-1740836355399.png

 

0 16 454
16 REPLIES 16
Top Labels in this Space