Problem with File and Concatenate

[B18ANU]

Hi,

I`m currently running in some trouble with the Column Type - File and Concatenate() function.
I have two tables and im trying to copy/insert the [Invoice File] column from table A in to table B. Invoice file holds a pdf thats stored in “Documents/Invoices/Example.pdf”

Case A :
If i use TableB[Invoice File] = TableA[Invoice File] i get : " Example.pdf "
This throws an error in the app because the path of the file is not defined, just the name.

Case B :
If i use Concatenate(“Documents/Invoices/”,TableA[Invoice File]) i get : “Documents/Invoices/https://www.appsheet.com/template/gettablefileurl?appName…”
When i click the link it takes me to the right file but because the path is in front of it it does not work in app.

Case C :
If i use Concatenate(TableA[Invoice File], “a”, “b”, “c”) i just get “Example.pdf”

How do i get the proper path set in table B from cell in table A ?