How to use data from a previous activity as a variable in a query in a next activity?
Hi community,
We'd like to know how can i use a data obtained from a previous activity as a variable in a following activity in a workflow?.
From delivery logs We obtain the profiles whose i sent an especific email, and in our ACS instance we have a custom resource called purchase orders related to profiles. To send a remarketing campaign we need to send an email to profiles with no purchase order after the the date we sent the first email. Until we hadn´t been able to pass the event date as parameter in the related purchase orders.
This is the workflow and configurations so far

1. We obtain the delivery logs


2. We reconciliate the profiles

3. We add purchase data



and this is how we try to filter the purchase orders after the first email was sent.

Thanks in advance for any help you can give us.