Assuming you have got all your required data from the website into the Datatable called DataFromWebPage
No need to use the List if everything is in the Datatable
Take 1 variable called TableHeader which contains the header of the html table. You can add your own table styles here like width etc.
Then another called TableBody which is generated dynamically within the loop as below
and then after the loop close the table by using </table> to the header and body.
In line 7 concat all 3.
FullTable = Header + Body + </table>
This is the FullTable html generated after running the process.
<table>
<tr>
<th>Company</th>
<th>Contact</th>
<th>Country</th>
</tr>
<tr>
<td>Alfreds Futterkiste</td>
<td>Maria Anders</td>
<td>Germany</td>
</tr>
<tr>
<td>Centro comercial Moctezuma</td>
<td>Francisco Chang</td>
<td>Mexico</td>
</tr>
<tr>
<td>Ernst Handel</td>
<td>Roland Mendel</td>
<td>Austria</td>
</tr>
<tr>
<td>Island Trading</td>
<td>Helen Bennett</td>
<td>UK</td>
</tr>
<tr>
<td>Laughing Bacchus Winecellars</td>
<td>Yoshi Tannamuri</td>
<td>Canada</td>
</tr>
<tr>
<td>Magazzini Alimentari Riuniti</td>
<td>Giovanni Rovelli</td>
<td>Italy</td>
</tr>
</table>
whose output looks as below when run in an html editor
You need to use the FullTable variable in your Send email with Html turned on.
Here is the full code of the sample flow.
Copy paste it into a blank flow and check.
@@timestamp: '03/15/2022 02:52:32'
@@source: 'Recorder'
@@culture: 'en-US'
WebAutomation.LaunchChrome.AttachToChromeByUrl TabUrl: 'https://www.w3schools.com/html/tryit.asp?filename=tryhtml_table_intro' AttachTimeout: 10 BrowserInstance=> Browser
WebAutomation.ExtractData.ExtractHtmlTable BrowserInstance: Browser Control: $'''html > body > div:eq(4) > div:eq(3) > div > div > iframe > html > body > table''' ExtractionParameters: {[$'''Value #1''', $'''Value #2''', $'''Value #3'''], [$'''''', $'''''', $''''''] } PostProcessData: True ExtractedData=> DataFromWebPage
SET TableHeader TO $'''<table border=1>
<tr>
<th>Company</th>
<th>Contact</th>
<th>Country</th>
</tr>'''
LOOP FOREACH CurrentItem IN DataFromWebPage
SET TableBody TO $'''%TableBody%
<tr>
<td>%CurrentItem['Value #1']%</td>
<td>%CurrentItem['Value #2']%</td>
<td>%CurrentItem['Value #3']%</td>
</tr>
'''
END
SET FullTable TO $'''%TableHeader%
%TableBody%
</table>'''
Display.ShowMessageDialog.ShowMessage Message: FullTable Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
# [ControlRepository][PowerAutomateDesktop]
{
"ControlRepositorySymbols": [],
"ImageRepositorySymbol": {
"Name": "imgrepo",
"ImportMetadata": {},
"Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}"
}
}
You might need to add the variables.
Also the UI elements wont get copied but you need to extract the full table as shown earlier.
Also I have shared the URL of the sample website I am using, it is in the Launch action.
