In above image there is a table in a application. so what the bot will do is it will check the Buy column in buy it will only check the Sell segement in sell segement row there is another column Brok amt,so that brok amt should not be 0 if it is 0 it will mail the user that this row contains 0 brok amnt.
Use extract datatable activity to read the table data into a datatable
For Each Row in Datatable
- If (row("Buy").ToString.Contains("Sell") AndAlso row("Brok").ToString = "0")
- Send Outlook Mail Message (configure mail settings and content)
Use Table Extract Data to extract the data from the application and store the output in a variable say dt_data which is of DataType System.Data.DataTable.
After that you can use any of the below process.
dt_ZeroBrokAmt = (From row In yourDataTable.AsEnumerable()
Where row.Field(Of String)("Buy") = "Sell" AndAlso row.Field(Of Decimal)("Brok amt") = 0
Select row). CopyToDataTable()
dt_ZeroBrokAmt is of DataType System.Data.Datable.
→ Use Read Range Workbook to read the dt_ZeroBrokAmt. Make sure to remove Add Headers option
→ Use Create HTML Content and in Open Editor click Map Data Value give table and pass the dt_ZeroBrokAmt variable. Store the output
→ Use Send Outlook Mail Message to send email and in body you can pass the variable of Create HTML Content output variable.
Happy to help if faced any difficulties
Regards
@mkankatala i didnt find the html content activity.
Create HTML Content activity comes under UiPath.Mail.Activities . Dowload the package and you can find the activity.
Hope it helps!!
