Need help with Lookup

Help Activities
, ,
1

Hello, I require help with my workflow.

I need the UiPath to go to my email inbox and for each sender’s email, the UiPath will then lookup the master list (ExcelAllCases.Sheet1) for the sender’s email and i want it to extract the whole row of data. Finally, I want it to copy and write the extracted info into a new sheet (ExcelAllCases.Sheet2).

The image shows a workflow in an automation tool for processing unread emails with attachments from a specific Outlook folder, limited to the first 100 emails. (Captioned by AI)
The image shows a workflow in an automation tool for processing unread emails with attachments from a specific Outlook folder, limited to the first 100 emails. (Captioned by AI)970×711 24.9 KB

The image shows a flowchart of a software process that assigns an email address to a variable, reads data from an Excel workbook, and then looks up a specific contact name in the data table. (Captioned by AI)
The image shows a flowchart of a software process that assigns an email address to a variable, reads data from an Excel workbook, and then looks up a specific contact name in the data table. (Captioned by AI)731×712 22.3 KB

This image shows a sequence of actions in an automated workflow to search for a value in "Contact Name" column from a data table and write the output to "Sheet2" in an Excel workbook. (Captioned by AI)
This image shows a sequence of actions in an automated workflow to search for a value in "Contact Name" column from a data table and write the output to "Sheet2" in an Excel workbook. (Captioned by AI)926×706 12.3 KB

2

Hi @mnurhaikal ,

can i get more info about your flow, now are you facing any error, if yes please share error

3

@mnurhaikal

I dont see you assigning a value to dt_output…also instead of lookup as you need whole row…use a filter datatable and write the output of it to a different sheet/file

cheers

1 Like
4

A UiPath workflow debugging session displays an error message indicating "Write Range Workbook: Object reference not set to an instance of an object," suggesting a variable or object is not properly initialized. (Captioned by AI)
A UiPath workflow debugging session displays an error message indicating "Write Range Workbook: Object reference not set to an instance of an object," suggesting a variable or object is not properly initialized. (Captioned by AI)1482×533 41.1 KB

This was the error. I kept getting “Write Range Workbook: Object reference not set to an instance of an object.”

5

This are the activity properties:

This image shows a workflow in an automation tool where an Excel workbook's data is read, a data table lookup is performed for a "Contact Name" using "SenderEmail", and the data is written back to the workbook. (Captioned by AI)
This image shows a workflow in an automation tool where an Excel workbook's data is read, a data table lookup is performed for a "Contact Name" using "SenderEmail", and the data is written back to the workbook. (Captioned by AI)1311×719 44.8 KB

This image depicts a workflow in UiPath Studio, which reads data from an Excel sheet, performs a lookup in a data table for a specific contact name based on an email address, and then writes the output to a workbook. (Captioned by AI)
This image depicts a workflow in UiPath Studio, which reads data from an Excel sheet, performs a lookup in a data table for a specific contact name based on an email address, and then writes the output to a workbook. (Captioned by AI)1330×715 50.4 KB

The image shows a data table lookup and writing operation in UiPath, where contact names from an Excel table are being searched using an email lookup value, and the results are written to a different sheet in the workbook. (Captioned by AI)
The image shows a data table lookup and writing operation in UiPath, where contact names from an Excel table are being searched using an email lookup value, and the results are written to a different sheet in the workbook. (Captioned by AI)1357×720 45.7 KB

This is the example excel sheet:

The image shows an Excel spreadsheet titled "sheet 1" with columns for Case ID, Contact Name, and Case Subject, containing data such as email addresses and corresponding subjects for cases. (Captioned by AI)
The image shows an Excel spreadsheet titled "sheet 1" with columns for Case ID, Contact Name, and Case Subject, containing data such as email addresses and corresponding subjects for cases. (Captioned by AI)844×365 19.5 KB

A spreadsheet titled "Sheet 2" with columns for Case ID, Contact Name, and Case Subject is shown, but it is currently empty except for the column headers. (Captioned by AI)
A spreadsheet titled "Sheet 2" with columns for Case ID, Contact Name, and Case Subject is shown, but it is currently empty except for the column headers. (Captioned by AI)781×466 12.9 KB

So if the sender email address is (“b@gmail.com”), i want UiPath to go to MasterList which is “Sheet1”, lookup for email address (“b@gmail.com”) and copy the (“Case ID, Contact Name & Case Subject”) on to “Sheet2”.

Thank you!

6

@mnurhaikal

cellvalue is not a datatable…that is the issue…and as per error it is clear the dt_output is emtpy as mentioned…

better as mentioned above use filter datatable instead of lookup

cheers

7

Thank you for the advice! Filter datatable activity works! Thank you for the help sir!

1 Like
8

I have a follow up issue. Now the filter activity only returns one row of data when I have 13 emails in the folder. It did not read and return the other rows of data.

9

@mnurhaikal

so 13 rows have same email?

if so you would get 13 rows ideally…if 13 have differnt emails as per your initial requiremnet each time in loop it matches you need new one…if you need all loop values in single sheet then use merge datatable in loop after filter and then after loop write all data at once

cheers

10

The 13 emails have different email address, subject and body.

Will the above still work the same?

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.