Hi,
I have one use case like below screenshot:
So how to copy and check if available go next step and if emp I’d not present then send email in uipath
Hi,
I have one use case like below screenshot:
Hi @sayali_rokade,
welcome to the community.
Thanks
Basically we have two files one is emp file and input file so we need to copy from input and check in emp file how to do that part in loop for every file in share folder
Hi @sayali_rokade,
If possible can you share us a sample file?
Or let us know the columns present in both the excel.
Regards,
@90s_Developer
I have one doubt, if both files match the emp id, what to be done, if mismatch what to be done?
Regards,
@90s_Developer
We need a clarification you mentioned above bot would open a file from shared file
I want to know which type of file is your input ?? Whether (pdf,excel )?
Based on your input only we give solution for your issue
Thanks
Robin
I have two excels .will share screenshot.so m coping emp I’d from input.xlsx and search in employee.xlsx if I’d present then login to next page if I’d not present sent outlook mail that do it manually
Pls send senario if anyone have.
I assume that your shred file is in your local machine
so that the two input files with Read range activity
use for each row activity to iterate excel data
use if activity to check employee id
Finally use Open browser or attach browser in Then block to login a webpage , create a counter variable to verify the employee id exist or not
check that counter variable in the termination of first for each activity , put send outlook mail activity in that else block to send outlook mail
Hope it solves your issue
Thanks
Robin
Thanks for your efforts will try in my flow
Okay update us once you got your desired solution
Thanks
Robin
@Robinnavinraj_S I tried this but it is checking row by row in emp excel and in emp have lot of data so can we use filter activity so that we can copy empID from input excel and directly filter in emp ID column in employee excel so that only matching value we get?do u have any solution for this
@90s_Developer if match then login to next page with matched id and if not then send email.
So basically we coping I’d from input excel and search that perticular I’d in employee excel if found then with that I’d login
Hi @sayali_rokade,
Use the if condition and check whether both the excel has the same excel id. If matched, in then block, develop the logic to login and process further steps. In the else block, leave as blank.
Regards,
@90s_Developer