Issue or bug with link to generated files on google drive (solved)

[stefanasks]

On the way create an action to an exported file on google drive I found an issue, maybe a bug.
I made this setup:

• A Bot that creates files with filenames from given table data
• add data source to the google drive directory
• create a LINKTOROW action with a select on the directory table, conditioned with the given table data - that does not work (properly)
• solved the problem by moving the select into a virtual column and used it in the LINKTOROW action instead.

So here the action that doesn't work properly (explain below what that means)

LINKTOROW(
  top(
    select(
      drive_documents[_ID], 
      [File] = concatenate([ID],"_client_contracts", ".xlsx")
    ),
    1
  ),
  "drive_documents_Detail"
)

This completely does not work in desktop preview, the action never finds anything.
In Mobile preview always only the first entry from the google drive table is found, not matter the search conditions.

Assuming that there must be some sort of a timing problem, I moved the select above into a virtual column in order to get this solution:

LINKTOROW(
  [_export_client_contracts],
  "drive_documents_Detail"
)

This works like a charm.

So I don't know why the select does not work in the LINKTOROW method directly. I can only assume that this must be a bug.