Excel Automation for finding user and add it to another sheet

Help Studio
, ,
1

Hi,
I have following requirement.

I have excel sheet with UserName. I have to take input from user for UserName. If the name exist in the excel sheet then it will log the status in another sheet with success. If the name don’t exist, it will log the status as Failed in another sheet. For Failed attempts, it should allow to enter the name for three times, and then it should give the status as locked. Please find the excel sheet.
Login Tab has UserName
Login Attempts has login Status…
Login Attempts worksheet should be blank in the begining. once any body try to input Username, it should append the following details.

We don’t have access to Active directory, hence we have to work this way for few months.

Please help
Failed_Login_Attempt_Spreadsheet.xlsx (13.8 KB)

1 Like
2

Hi @khooshbu.jani

Please find the attached workflow, i’ve developed the solution, try running the workflow

output folder path is - “Login_Attempt\Data\input\Failed_Login_Attempt_Spreadsheet.xlsx”

Login_Attempt.zip (17.0 KB)

Happy Automation :grinning:

3

Thank you for your help. I got that