Get Color And send Mail to Leads

[Nandhuba (Nandhini Balasubramani)]

@Shubham_Akole…Merge 2 excel sheets
You can read both excel sheets, let’s name them dt1 and dt2, use Write Range dt1 on the new excelsheet (excel sheet 3), then use Append Range using dt2 as your input on the same excel sheet. Then create separate variable for mail I’d containing coloumn and pass in onto To field of send SMTP mail message.
For more details👇

How to merge two excel sheets when we have few items common between them

we have two excel sheets1 and sheet2. In sheet1 I have columns like “Item”,“Price”,“Quantity” and the same set of columns in sheet2. I want to make a 3rd excel sheet which will contain,both the common items and the rest of the items.I had used join data table activity but it is not working for me. I am attaching here all the files. Main.xaml (13.7 KB) Excel1.xlsx (7.8 KB) Excel2.xlsx (7.8 KB) table3.xlsx (8.4 KB) Plz. help!!