I have an Excel sheet with multiple columns, e.g. names, values, etc…The table is in the following format:
I want to compare values from both columns ‘Value1’ and ‘Value2’, so if Value1-Value2 > 0 then send email to corresponding user with the selected data as an attachment, in this case to the user ‘Lastname4, Firstname4’ (one row only).
Also, can we create the email address on the fly based on the column ‘Name’ in UiPath? In Excel the formula to do so for the 1st row would be something like this: =CONCATENATE(TRIM(MID(A2&"."&A2;FIND(",";A2)+1;LEN(A2)));"@domain.com")