70
Hi,
I am trying to send information in a tabulated way via email to the user. How do exclude columns which are empty from the HTML table that will send via email to users.
For example: My table contains columns such as Program Name, Program Lead, Program Description, Program Stage. If the column Program Description is empty, then it wont get included in the HTML table. I just want to send email with information what are available and avid all empty columns to confuse people.
Hi there,
Are you using the "Create HTML Table" action to do this?
You can use the "Select" action before turning it into an HTML table to exclude blank columns.
So, for example, you'd first iterate through each column - if it ends up empty, then don't add it to your mapping variable - if it has stuff, then do add it.
You can use an Array variable in the format of:
{
"Key":"Value",
"Key":"Value"
}
To identify what should be pulled with the Select.
Then when you pass it to the Create HTML Table, and use "Automatic" - it'll just make a table from those unblank columns.
R
Share
Report
All responses (
Answers (
