Hi,
I'm a South African and need some advice on which actions to use for the following tasks I want to automate with Desktop Attended RPA license.
Current process (manual)
Step 1: Open a file manager, signing in and search in a certain directory for a file. (File is usually received outside business hours)
Step 2 : If the file exists, then I need to check if the system processed the file correctly, by creating a new file in another directory.
Step 3: I also need to open an inhouse SQL DB enquiry application and run a few queries to check if the system processed the file correctly. (audits)
Step 4: I need to note some of the information from the queries on a "MS List" for operational staff to monitor.
Step 5: If all the checks are done and correct, I need to FTP the newly created file to another location and receive a response from the location that they received it. And again note that on the MS List.
I have built a couple of RPA flows in our company so I know the basics, I have also started playing with Desktop Recorder and tested it to see if I can open an application on my desktop, sign in and run a query successfully.
But I need some advice, because I see there are many actions I can take, but I need to know which ones would be the best for the steps I have above. I don't have a lot of time to really dive into this deep because I need to prove that Power Automate will be able to assist our business processes and produce a POC ASAP? Can anyone maybe assist me?
Also I have the current licenses :
- Power Automate RPA Attended
- Common Data Service Attended RPA
I want to do the POC in "Attended flow", but obviously the actual flow will have to run on Unattended eventually, which license will be best to get then? I want to be able to automate about 12 -15 user's tasks on their desktop eventually.
The reason why I think that attended desktop flow wont necessarily work is because I read an article that when your desktop is running an attended flow you wont be able to do anything else on your desktop, which is not what I want. I want to automate mundane tasks in the background which will give my operational people (users) time to do more client service related tasks.
Can anyone please provide some help or advise?
Riana Smit
riana.smit@qlink.co.za
