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]

Hmm, I posted a reply to this a couple days ago.  Not sure why it didn't 'stick".

It would be good to see how you implemented the Virtual Column.

The reason the original expression does not work is because the TOP() function returns a LIST of values.  It may only be a list of a single value but it is till considered a LIST.  The LINKTOROW() expects a single row key value and cannot be in LIST form.

If you were to simply replace "TOP" with "INDEX" - then you'll likely find the original expression works as expected.  The syntax of INDEX is similar to TOP.

Another approach is to use the ANY() function which returns the first value of the list.

I hope this helps! 

[stefanasks]

Due to network failures I accidentally posted this post three times.
However, on this permalink I responded with some of my tries . Single values from "INDEX" or "ANY" are included, even if they are not listed in the post.

For now I have a workaround for the problem and look at it later again.