05-17-2021 07:43 AM
In this video, we are going to learn about how we can achieve Power Automate Desktop load distribution and high availability using Machine Groups.
watch?v=BresOAJTAVY
Hello, we have a cloud flow that has a Power Automate Desktop action in it. It goes something this:
...
Save Excel file to SharePoint
...
Open that previously saved Excel file, run a macro (VBA), save Excel, close Excel.
Many different users from a specific team could actually trigger the cloud flow, but I want the power automate desktop flow to run in an attended mode (preferably on the computer from the user who triggered the cloud flow), because if an error occurs the user can interact.
Is there a possibility to run it on a machine group, but pass in machine dependent username and passwords. Imagine the machine group consists of Jeff's and David's laptops. When the workload gets distributed to Jeff's machine, power automate will log into Jeff's machine with Jeff's username and password, if the workload get distributed to David's machine power automate will use David's username and password?
What are my options to run an Excel Macro redundantly in an attended mode?