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>")))
Solved! Go to 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!.
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!.
User | Count |
---|---|
247 | |
105 | |
82 | |
50 | |
43 |