From a datatable, create a variable

[mark_rajkumar1 (mark rajkumar)]

Hi there,

How do i use a datatable to create a variable, as i need to send one by one email by inputting a row from a column after every loop when transaction is success.

[Gokul001 (Gokul Balaji)]

HI @mark_rajkumar1

To use a datatable to create a variable in UiPath, you can use the Build Data Table activity. his activity creates a DataTable according to a specified schema. You can customize the table to be created by clicking the DataTable button in the activity body.

Check out the docs

Activities - Build Data Table

@mark_rajkumar1

ne by one email by inputting a row from a column after every loop when transacti

You can use the Send Outlook Mail Message activity. You can use Output DataTable Activity to convert DataTable into String and then pass that String into Mail body

Check out the docs

Outlook Email Automation

Regards
Gokul

[mark_rajkumar1 (mark rajkumar)]

@Gokul001 how do i use the output datatable in mail activities, can elaborate?

[Harshith_Adyanthaya]

Hi @mark_rajkumar1 ,

Try this.

Add Excel data into Mail body

Hi Kuldeep, Mail_DataTableToHtmlText.xaml (16.6 KB) Use this workflow. Just input your datatable, you will get html text as output. You can use this text in the mail body. Make sure you have checked IsBodyHTML property.

Hope it helps.

[Gokul001 (Gokul Balaji)]

@Gokul001

Output DataTable

@mark_rajkumar1
This activity is to convert the Data Table into string format so that you can use the Values in the email Body as a string.

[mark_rajkumar1 (mark rajkumar)]

@Gokul001 i use Output datatable activity, with that i can input the datatable and column name for script to send email?