How to use data from a previous activity as a variable in a query in a next activity?

[olsalas711]

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.

[ramon_bisswanger · Accepted solution]

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

Note: you may need to add Max(purchase Date) or similar in the enrichment step

[Sukrity_Wadhwa]

Hi @olsalas711,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!