Data Table Format in HTML EMail

[DawnW (Dawn Wessell)]

All

Having an issue with Data Table format in HTML email…
I’m using Create HTML Content to insert a Data Table into my email as it needs to be dynamic as could have 1 - 10 rows etc.

I can get it all working, but my email looks odd, its not bringing through the headers of the DT, so its showing the first row of Data in the email table as bold and central (like a header) when it is data, not header etc.
I wouldn’t mind seeing the headers of the DT in the email or not seeing them and only seeing the data… I just can’t seem to find anything about formatting it (my resulting email body as below)…

Any ideas greatly appreciated…

[DawnW (Dawn Wessell)]

Maybe its how I’m writing the data to the Data table, and its over writing the headers…???
I’m simply adding the data to the DT with a Add Data Row:

[ppr (Peter Preuss)]

its a behaviour longer reported to UiPath.
Just insert a new line with the header names at the first position from the rows and use this fixed datatable.

But when any Column is not of datatype String, this workaround will not word, due we cannot place the header name e.g. into a int32 column.

So, in such scenarios we can generate the table block with data by our own and the place it within the template afterwards

Table HTML generation

• own custom modelling / code
• 3rd Party Activities which supports on this e.g. Marketplace

[vrdabberu (Varunraj Dabberu)]

Hi @DawnW

Try writing DTEmail1 to an excel file and read that excel file. Please uncheck the Add Headers option in the properties Panel of Read Range Workbook activity and say the output to be dt.

Pass dt datatable in Create HTML Content. This should help you get the table in email with Headers also.

Please refer the below thread for reference

How to send dynamic and multiple table in email body

Hi @satish.rathi59 You can use Create HTML content activity to create the body and insert table and save the output in a Variable. Pass this output in Body field in Send outlook mail message or Send SMTP activity and check the IsBodyHTML option in properties. → Use the Read Range workbook activity to read the excel and store in a datatable variable. → Click on the Open editor option in Create HTML content activity a window popsup. → In that window, click Add data values, and click on Add …

Let me know if you have any issues.

Regards

[ppr (Peter Preuss)]

@ppr

its a behaviour longer reported to UiPath.

E.g.

Edit / Create HTML Content - Missing header / First Datarow in Bold

Hi, I’m doing a simple exercise of extracting data table using Table Extraction from a website then send an email containing the table. I have no problem in extracting the table and saving it inside the project notebook excel file: nothing is missing including the header. But if I extract the table, save it as a variable then use it directly in the Send Email activity (Body: HTML), the header of the table is somehow missing. Sure I can do a turnaround by sending the table as attachment instead,…

[DawnW (Dawn Wessell)]

Add the Header row to the DT…!!!
So simple a fix, that I had not thought of, D’oh…!!!
Thank you very much…
Dawn