How is it possible to send the content of a complete column by email

[benedikt]

Hey everyone!
I’m brand new here and I need your help, please. I’m currently building an app where you select products from a catalog and this selection is summarized as an order. My order screen then displays the order. If multiple sales units of a product were selected, the quantities are summed up and the product number is shown only once in the order screen (using this method: here ). Now I would like to send the results from the order screen as an email, whereas just the product number and the summed up quantity is needed.
I would like to send this order by clicking one button using the “send email” action.

Thank you so so much for your help!

[ThinhDinh]

If you have the product number and quantity already, I think it’s just about having them as a template in the line item level, then join them together using a joined list column. Reference the joined list inside your email body.

[benedikt]

Thank you. I solved it by myself.
The problem had been that there are some empty cells in between because of the summation of articles with the same number. And when I directly made a list out of them there had been empty places.
But I changed this column then into an array. Then also the column where the article numbers are listed multiple times. „Subtracted“ them of each other. „Subtracted“ then the new column of the „full column“. So the array has really just the final values in and no empty element in between any more. And then made a list out it it works perfect thank you

[ThinhDinh]

@benedikt

The problem had been that there are some empty cells in between because of the summation of articles with the same number. And when I directly made a list out of them there had been empty places.

You should be able to create a query on top of what you already have, and filter only for rows that actually have the number.

Create a joined list on top of that query.