Skip to main content

Hi,

I would like to achieve an Action Flow where an Email would be send to the corresponding users/customers based on Customer or company code column value. ( for example, Based on the Company Code Value (say A), the email should be triggered to customers belonging to A. Similarly for other company codes say B,C, etc.).

 

How can we implement a dynamic filter for the above requirement to send mails accordingly.

 

Currently, we are doing it manually for every company code using router. Please find the screenshot below for reference.

imageKindly let us know how to proceed further.

 

Thank you in advance :)

 

FYI : @reenu.josep12​ 

Hi Reenu,

 

All you need to do is create a field (Column Item in Query data ) and use that field as your to statement,

 

In this case that would be

 

CASE WHEN COMPANY_CODE = 'A' THEN 'A@GMAIL.COM' END

 

Hope this helps!


Reply