How to Add Data Table content in mail body in REFramework without queue

[pooja_prasad1 (pooja prasad)]

Hi Team,
Good Morning!

Can anyone help me out to resolve in getting the headers content into mail body eventhough I have added into ‘DataTableToHtmlData’.

Because I am using REFramework without queue so in_TransactionItem.Specific Content(" Excel Column Header").toString won’t work as I change the transaction Item to DataRow from queue.

But I am understanding what variable should I use while using ‘Add Data Row’

Attaching the screenshot.

Best Regards,
Pooja Prasad

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi,
please check this link

UiPath | Create Framework for Linear Process using RE Framework | RE Framework | RPA | Beginners

Regards,
LNV

[pooja_prasad1 (pooja prasad)]

Hi Nguyen,

Yes sure, let me go through it.

Can we connect on Teams.

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @pooja_prasad1 ,
yes but now I can only inbox because in working time in company,
Can you inbox for me,
teams I can check in free time

[Vikas_M]

Hey @pooja_prasad1 ,
Please refer below thread , i have explained it in a similiar question

How to send text in table format in mail body

Hey @vnsatyasunil , You can build datatable with the 3 columns using Build datatable activity Populate the datatable with required fields After that there are 2 Solutions Method 1: Using Create HTML Content activity If you want to go through this activity directly then you wont be getting the headers so if you want column headers , write the datatable back to excel and then again read the workbook with ADD HEADERS Option Unticked After that send that Datatable to Create HTML Content and it…

Hope it helps you out!

[pooja_prasad1 (pooja prasad)]

Hi Friend,

I have invoked ‘DataTabletoHTML’ activity into Main and since it is loop data so have put build data table outside the loop and add data row inside it with Filter data table which will only send the error data into mail and not the successfully uploaded data, but still in mail it is not printing.

Can anyone share your email id or teams so that I can connect personally?

[Vikas_M]

@pooja_prasad1 ,
Can you check if your datatable is getting populated by add data row activity
Put a Breakpoint and check the datatable contents in watch panel

[pooja_prasad1 (pooja prasad)]

Hi Vikas,

I am getting error like ‘Add Data Row: Input array is longer than the number of columns in this table.’ so I tried to add ‘CurrentRow.ItemArray’. But the problem is like I want to filter put only those rows which has error in Status column.

Best Regards,
Pooja Prasad

[Vikas_M]

@pooja_prasad1, Can you share your add data row and build datatable activity screenshot

Check if the Column name and Column type of the columns are same as your data
Also what you can do/check is after adding the rows ,->outside of the loop Filter the data table based on status column(Check if the cases of the words are similar with what you give the condition)

Also after filtering check if the datatablevariable.Row.count > 0
Send mail only if the row count is greater than 0

[pooja_prasad1 (pooja prasad)]

Hi Vikas,

Yes sure!

Headers in Build Datatable and Add Data row is same, only thing is I kept it inside for each datatable loop so that it can put alll content, but it only putting header and no content inside that havind data with error status.

[pooja_prasad1 (pooja prasad)]

Hi Vikas,

Still I am not getting any data in my mail even after placing outside the loop.

Can you tell me where exactly I need to add the condition ( Also after filtering check if the datatablevariable.Row.count > 0 ) ?

Can you call me?

[Vikas_M]

Hey @pooja_prasad1 , Just filter the rows whose some columns are empty
So for that assign the condition as below screenshot

Hope it helps you!