Replacing string "[table]" with datatable. Assuming it to be created for mail body

Help Activities
, ,
1

Hi Team,

In my project, I am having config file entry variable as below:

"Hello Team,

Please find below table: [table]

Best Regards,
RPA Team"

My table:

image
image759×529 11.4 KB

I want to add a datatable in place of value “[table]”. But I am getting a NULL value.

Exprts, please help fast : @Anil_G, @AJ_Ask , @Kismet_Tosun

2

Hi @hacky

Use Create HTML Content activity

Regards,

3

Why not using clasic config style

An Excel spreadsheet named "Config.xlsx" is open, displaying configuration settings with columns "Name" and "Value". (Captioned by AI)
An Excel spreadsheet named "Config.xlsx" is open, displaying configuration settings with columns "Name" and "Value". (Captioned by AI)1000×374 23.9 KB

4

Bro but I want to insert a datatable value within the string.

5

Thats exactly what I am doing. I need help with replacing ‘[table]’ keyword with my actual datatable like I attached on my question post.

6

Try

The image provides a step-by-step guide on how to insert a DataTable into a string within UiPath, including converting the DataTable to a string using LINQ and replacing a placeholder in the email template. (Captioned by AI)
The image provides a step-by-step guide on how to insert a DataTable into a string within UiPath, including converting the DataTable to a string using LINQ and replacing a placeholder in the email template. (Captioned by AI)686×787 30.1 KB

String.Join(Environment.NewLine, MyDataTable.AsEnumerable().Select(Function(row) String.Join(“,”, row.ItemArray)))

emailBody = emailBody.Replace(“[table]”, tableString)

7

I need headers also from my table to be in the list

8

experts. please help : @postwick , @ jitendra.saroj

9

Hi @hacky,

You can try to convert your datatable into html string format.

The image contains VB.NET code that generates an HTML table from a DataTable object, including columns as table headers and rows as table data cells. (Captioned by AI)

10

As Rashmi said, you have to convert the datatable to HTML. There are lots of posts here on how to do this. Then you have just a HTML string and can use Replace to put the HTML string where [table] is, as Kismet mentioned.

11

Hello Team,

quick update.

in my case, output datatable followed by string manipulation operations worked.

thnks for your inputs.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.