I have an order form (related order details) and a workflow triggered with all updates on orders form.
Problem is that, when I change order and included order details, Workflow runs and sends an invoice as an attached email. But the invoice does not include the lastly changed order details. First sync always runs with empty order details values.
I changed the orders table a bit to fire a data-sync first then change a row to trigger send email action. It works but it is not user friendly.
Is it expected behavior? Or am I missing something?
Is there a better solution?
Note: database is google sheets.