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. 

  • If the desktop flow is configured to only run a specific laptop/desktop and that user's laptop/desktop is turned off (maybe he/she's out-of-office), the desktop flow will not run.
  • if we configure in unattended mode on a server with for instance admin account, the flow will not run when the admin is logged in on that server, and we can not correct any possible errors because it is running unattended.
  • if we configure in attended mode on a server with for instance the admin account, the flow will not run when the admin account has no active Remote Desktop connection to the server, in addition the admin will probably not be aware of any desktop flows.

 

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?