Changing dynamic fields while doing Email Automation

[Vikram212 (Vikky)]

Hi @Florent_Salendres @badita @vvaidya
can any one advise how to replace several dynamic fields while sending email

my steps are as below:
create new email
search for template based on certain query
check if any dynamic field are present or not - if present then replace
send the mail

fyi there are more than 10 dynamic fields in every template
so i am trying put all these 10 dynamic fields in config file or should i create a dictionary

TIA

[Florent_Salendres]

Hi,

I like to approach that kind of problem using a textfile for the as template:

ex: 
 
Dear @fullname  

Please find attached the report data:

@reportdata 

Please reply before : @replybefore

You can then use an expression like this one replace:

strBody = strBody.Replace("@name","Florent").Replace("@reportdata","SomeDataTableOuput").Replace("@replybefore",Now.ToShortDateString).

Hope I understood your query correctly, if not could you please shared more detailed example?

Cheers

[Vikram212 (Vikky)]

Thanks @Florent_Salendres
i have 20 different templates
each template have some dynamic fields which may or may not be present another templates
for example
template1 has dynamic fields as {fullname},{birth place},{reportdata}
template2 has {first name},{reportdata}
template3 has {fullname,replybefore},{age}
etc

so how should i build a logic to find these dynamic fields and then replace all of them
should i create all known dynamic fields in dictionary ? if yes how can i acomplish

[Florent_Salendres]

If you replace something that does not exist, that will simply.

Wouldnt this still handle your case then?

[Vikram212 (Vikky)]

do you mean to have just one equation for all cases so i need not setup a logic to find particular dynamic field
as below
strBody = strBody.Replace(“@name”,“Florent”).Replace(“@reportdata”,“SomeDataTableOuput”).Replace(“@replybefore”,Now.ToShortDateString).

[Florent_Salendres]

Exactly, if in one of the template, a field placeholder isn’t present it will simply ignore it.

[Vikram212 (Vikky)]

well thats solve my half problam …Thank you very much
another query is about how should build a dictionary for all these dynamic fields
{name}
{reportdata}
{replybefore}
{age}
{birthday}
{lastname}
any idea?

[Florent_Salendres]

I would use an invoke workflow having arguments with the replacement values.
A dictionary is a viable solution if you really have many of them, coming from difference sources.
Maybe you should consider having those values in your QueueItem, if it fits your design.

To add to dictionary, you have an example on this post.

How to use Invoke Method to Add items to Dictionary

Hi Steven, Thank you the response. I understand that there is an “Add to Dictionary” activity available for this task. However, I want to know how to use the “Invoke Method” activity for this task and similar ones. Let me briefly describe my query as below: I have my Dictionary variable dict setup as below. [1] And I use the Invoke Method Activity as below. [2] And I have the properties for the Invoke Method Activity as below. [3] Now I want to do something likes this: dict.Add(“ke…

A datatable is a viable option as well, it depends on your preference.

Cheers

[Vikram212 (Vikky)]

Thank you very much