Lookup Path from Folder as a Table

[Stobber]

I have a table called `"photo"` which holds photos and their metadata. The photos are stored in Google Drive, and I also have that folder loaded as a table called `"photos_Folder"`.

Here are those tables:

I want a bot to set the `photo[file_url]` value whenever a new photo is added to the table based on this trick. It has to get the "photos_Folder[_ID]" value and concatenate that on the end of the Drive URL. I'm trying to do that by using LOOKUP on `photo[file_path]` and `photos_Folder[Path]`.

I'm using this expression. It's not doing what I want, and I don't really have a good way to troubleshoot it. Can anybody evaluate it and tell me what I'm doing wrong?

CONCATENATE("https://drive.google.com/uc?id=",
  LOOKUP([_THISROW].[file_path],"photos_Folder","Path","_ID")
)

Here is my bot configuration:

[Stobber · Accepted solution]

I fixed the expression. It needed to look for the `photo[file_path]` value as a substring of `photos_Folder[Path]`.

CONCATENATE("https://drive.google.com/uc?id=",
  SELECT(photos_Folder[_ID],CONTAINS([Path],[_THISROW].[file_path]), TRUE)
)