Collection HTML format

[Coopedup]

Hi all,

I'm building a PDF report option which will have a dynamic table (can have different number of rows). I've found some very good examples on here, which are great, but I'm failing to get a filter option added into it. 

Can anyone help with where I've gone wrong? 

Create a collection of a notes SP List, filtered on a Title value. Then format the returned rows to the HTML text, which I'll then use with in a create PDF button.

ClearCollect(colNotes; AddColumns(Filter('Register Notes', Title = varID),Table({
    DateAdded: DateAdded.Text;
    NoteDetails: NoteDetails.Text;
    AddedBy: AddedBy.DisplayName
    }));
    "pdfHTML";
    "<table border= '1'>" & 
    "<tr><th colspan='2'>" & DateAdded & "</th></tr>" &
    "<tr><td>" & NotesDetails & "</td><td>" & AddedBy & "</td></tr></table>")))

[Coopedup · Accepted solution]

So this was simplified. I already have a gallery with the filtered details in. So rather than building a new collection I contact the gallery data within my create PDF htlm button. And all worked for me!.