Hi,
I have the following action flow:
with the following query:
SELECT Id, (case when @Nome = 0 then Nome end), (case when @Apelido = 1 then Apelido end), (case when @Idade = 0 then Idade end) FROM {Aluno};
with the following structure:
In the SQL1 query, I have some empty columns and when I export to Excel file, all columns are exported. How I can export only the filled columns?
Thanks.
Hi Catarina,
Unfortunately, it is not possible to dynamically decide which columns to include in an Excel export. You either need a RecordListToExcel for each possible combination, or you must resort to one of the Forge components that can output an Excel.