I have Zap that I use to grab data from Kintone app using a webhook as a trigger (from Zapier). This Kintone app has a table in it that a user fills out. In that table is a field that is Multiselect, so the user can select more than one item. That table can multiple records and each record could have multiple items selected in the Multiselect field.
This is an example:
In my Zap I call that data to write it to an Exchange email using HTML body. When I use
I use the Line Itemizer to format the data so that I can build a table in the HTML body of the email BUT everything looks great until I get to the Disposal Reasons (Multiselect Field) because of the comma it separates that field wrong. I the example below the Disposal Reason for the 1st record should be “Cannot Test/Recert” and “Expired” then for record 2 of the same table it should be “Slow Mover” and “Small Qty”. The problem is the comma. Because it separates by the comma to take each Disposal Reason and add to the existing record but adds new lines. See my snapshot of email below. I’ve been playing around with formatting but I cannot get it to work. So in short, Cannot Test/Recert and Expired should be in one table record and Small Qty and Slow Mover should be in the 2nd record of the same table, see above snapshot of the Kintone record. Any help would be greatly appreciated. Thank you.
