I am completely new and inexperienced in the field of automation/RPA.
I have been given the task/exercise of creating guest accounts for users in Azure. The information that must be provided is full name, first name, last name, email, and the department in which this person works (all of which is stored in an Excel file).
The problem I have now is that once a user has been created, the process has to be repeated. Is there a way to run the process again and at the same time delete the already created users from Excel or mark them as completed?
→ Create a Column called status manually in your excel file.
→ Read the excel and store in a datatable using Read Range workbook activity.
→ Then use the For each row in datatable activity to iterate each row in the datatable.
→ Inside For each insert the Ui activities (Type into activity) to enter the data to the fields in Azure.
→ After entering all data then use the assign activity to update the status,
- Assign -> Currentrow("Status") = "Completed"
→ After for each row in datatable activity use the write range workbook activity to write the same datatable to same excel.
Use the For each row in datatable activity to iterate through each row in datatable it will take one by one row and enter data to Azure portal.