i have one excel which consist of column “Requestors”, i want UiPath logic in such a way that i need html which consist of column “client”,“Asset” and “service” but if the name is duplicate in the column “Requestors”, then BOT will keep single name and give all “client”,“Asset” and “service” in html table against that requestor name.
I have to iterate though each row in excel sheet and then sent that table to requestor though email
Testing List for BOT 26.03.2026.xlsx (9.7 KB)
Hi @sshitol
You can achieve this by grouping the data based on the Requestors column.
1 Read the Excel file into a DataTable using Read Range.
2 Use LINQ / Group By on the Requestors column to get distinct requestor names.
3 For each unique requestor, filter the DataTable (DT.Select(“Requestors = ‘Name’”)) to get all related rows.
4 Build an HTML table using the columns Client, Asset, Service for those filtered rows.
5 Send the email to that requestor with the generated HTML table in the body.
If solution works for you please mark as solution
Thanks
Handling the Groups and aggregating the client, Asset and Service can be done by grouping the data:
creating the HTML Table from the resulting datatable can be done
- with the help of: Activities - Create HTML Content
OR
- generated by custom implementation / modelling flow
BTW: the create hatml content Activity had a bug (that maybe is still existing) and will ommit the the Header row (first line). This needs to be corrected before / afterwards
can you give me the code