Start: Select() in Docs Template

[Nicolas_Feldman]

Hello everyone.

I am using this formula on a Google Doc template for my PDF generation Workflow:
SELECT(Listas de asistencia[Nombre],and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=“asistencia”))

Which works perfectly and brings back these results in the PDF file:

What Im trying to do is to present these into a table so they can sign next to their name…

I´ve tried
<<start: SELECT(Listas de asistencia[Nombre],and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=“asistencia”))>>
<<[End]>>

But this didn´t work. The PDF is not generated. So I went into the Workflow Log and found this error:
(the SELECT expression) should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

Im kind of stuck here, I dont understand why the expression works fine without the “start” function, and it doesnt when I try the enlist the results.

I also tried creating a Virtual column with the same SELECT formula, and added <<[VCName]>> to the Template. The test results of the formula for the VC are correct, but when the PDF is generated I just get blank spaces and commas (separators):

[Steve · Accepted solution]

The SELECT() expression used in a <<Start>> tag must produce a list of key column values; if it produces a list of anything else, it won’t work. Really, FILTER() is a better choice than SELECT(), as there’s no way to get the wrong values using FILTER().

Try this:

<<start: FILTER("Listas de asistencia",and([_thisrow].[Fecha asamblea]=[Fecha asamblea],[Asistencia]=“asistencia”))>><<[Nombre]>>
<<[End]>>

[Nicolas_Feldman]

Thanks @Steve! Once more you nailed it!