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.

[WillowMobileSys]

How is your Virtual Column defined and assigned??

The TOP() expression in your LINKTOROW() function returns a LIST of values - in your case a LIST of 1 value.  The LINKTOROW() function expects a single value - not contained in a list.

Try this:

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

The ANY() function returns the first VALUE in the list. 

EDITED:  I guess alternatively you could also replace "TOP" with "INDEX" without any other changes and that would work as well.

[stefanasks]

These are some of the actions I tried in "App: go to another view within this App" and did not work:

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

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

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

LINKTOROW(
  any(select(drive_documents[_ID], find([File], [_THISROW].[ID]) > 0)),
  "drive_documents_Detail"
)

LINKTOROW(
  any(select(drive_documents[_ID], find([_THISROW].[ID], [File]) > 0)),
  "drive_documents_Detail"
)

LINKTOROW(
  index(select(drive_documents[_ID], find([File], [_THISROW].[ID]) > 0), 1),
  "drive_documents_Detail"
)

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

But when the select runs in a virtual column [_export_client_contracts] to be included in the action:
LINKTOROW([_export_client_contracts], "drive_documents_Detail")
all examples from above work, no matter the column type like: List(Text), List(Ref), Text, Ref ...; completely does not matter, what is kinda impressive.