Email Subject with Dynamic data from input

[gemi9rahul]

Hi,

I am looking for dynamic subject line for my emails generated by Alteryx, like it should be Sum of Absolute number and grouped by a column and converted to Million.

my data has ABS column, so total of ABS should be captured on Subject line based on a specific group and then that number should be converted to millions like 10mn or 15mn

[DataNath]

Hey @gemi9rahul, here's how you could go about this. Screenshots aren't working for me at the moment but all we're doing is summing the [ABS] values and then temporarily converting them to a string in a Formula tool so we can place the 'mn' suffix at the end. Following that, we just need to tick 'Use Field' next to Subject in the Email tool and we can reference this field that we just created with the reformatted millions value. Workflow attached - hope this helps!

[gemi9rahul]

Thank you DataNath

[miccassi]

Hi DataNath,

Wondering if you can help me wit something similar. 

I built out an email function where I add an input file of items pending, and Alteryx creates X number of emails based on who the items are pending with.

Rather than having the same subject for each mail, i am trying to make the subjects dynamic to say something like "Items pending for [Assigned To]"

Assigned To:

Bob

Casey

Anthony

Michael