Data Table to HTML Activity

[Chetan_Wagh]

Hello All,

I am using data table to HTML activity and sending output of it in Email body. However i want the data in Table format and not HTML as i am getting in the email

Also, do i need to put anything in border here

Getting Output like this

Want it like this

Any help will be appreciated.

Thanks

@Harshith_Adyanthaya

[Harshith_Adyanthaya]

Hi @Chetan_Wagh,

Try output datatable activity. Hope it solves your problem.

Input:

Name	Age	Salary
A	18	25000
B	20	25000
C	26	30000

Output:

Name, Age, Salary
A, 18, 25000
B, 20, 25000
C, 26, 30000

[Chirag_Shetty_Divakar (Chirag Shetty)]

@Chetan_Wagh

Hope this helps

DataTableToMail.zip (20.8 KB)

Regards,

[Jithesh_R (Jithesh Karkera)]

Hey @Chetan_Wagh ,
You can make use of "Create HTML Content " Activity.
You can create variable there and you can pass the dynamic values inside.

Regards,

[Chetan_Wagh]

But that converts Data Table to String if i am not wrong. I want output in Table format. Like the one in this image

[Harshith_Adyanthaya]

Datatable means its in table format. It will be visible in table format by using it in html.

[Jithesh_R (Jithesh Karkera)]

Hey @Chetan_Wagh ,
Check this If you can use “Create html Content” Activity .You can directly add table to it.

Output :

Note : Make sure to tick the “IsbodyHtml” property in send outlook mail message

Regards,

[Chetan_Wagh]

Thank you for your answer.
But the row column count isn’t fixed

[Jithesh_R (Jithesh Karkera)]

@Chetan_Wagh ,
Yeahh even if the columns or rows are dynamic that doesn’t matter you can just pass the entire DataTable inside this activity and this will replicate in your mail .

You can refer this workflow for your reference

DataTableToHTML.zip (2.1 KB)

Regards,

[Chetan_Wagh]

Thank you @Jithesh_R .

Using data table to html activity it worked. Just did not enable Is HTML body checkbox