Whatever the case is we need to “make a change” in data somewhere within appsheet to trigger workflow. So called Event Listener. All the app is built in that way, Appsheet is not exceptional.
I m not sure how your app is currently build, but to achieve your goal, this should be easiest set up.
As well as other posts, I need to have a look at your table/data schema to give a precise and exact advice, but let me give you a clue.
First, you have order table assumption. At the same time you have slice which will return the list of the rows out of the table such as stock or product that required to be ordered.
Then create the new column in order table by using virtual column with list type, and app formula to return the list of stock/product waiting for order.
Make sure to add “PlaceOrder” column in order table, and make it number type with initial value of 0.
Create new action to change the value in the selected row. This action will add incrementally 1 to the “PlaceOrder” field.
Create new workflow to send email, ONLY if [_thisrow_before].[PlaceOrder]<>[_thisrow_after].[PlaceOrder]
Then on firing action, [PlaceOrder] value change, in turn this will trigger the workflow to send the email with the list of product/stock waiting for order, whose list is dynamically generated by slice.