I am creating a shopping list app. I have made a slice view that only shows items with a quantity. Now I want to create an email action to send the full shopping list to myself or my wife However I am struggling setting up the email body template, so it generates the full list of all items from my slice. I can get it to display info from multipe rows using a SELECT function, however I need the email to display both: Category, Item, Unit and Quantity for all items in the list i.e. information from 4 columns, but per row, so the email body would look like e.g.
Thx for your fast reply. I need to select and retrieve data from all rows where value of column “quantity” is higher than “0”. Can you help me build this into the expression below?
I could not get your suggestion to work. I am constructing the email body of the Action function: “External: Send mail” and not the workflow function for sending mails by schedule. In the Action body I am not able to add fields using <>, <>
The closest I got was this: LIST(SELECT(GOSHOP[Item], [Qty.]>0))
However I need to add also [Category] and [Unit] per item selected. I have spent hours and cannot find a way to add more than one column to the function above.
Hope that you can help me out as this should be a pretty simple task…
Sure! As I understand normal workflows are scheduled to run at a specified time and cannot be triggered. I need to push the mail. If I can trigger a workflow using an action it could work. Can this be done, you think?