I have been using Power Automate now for a few months and can see the huge potential for myself and all my team. I have been especially impressed using the SQL connector to Get and Transform data to create custom reports. These have been a benefit to me personally but I'd like to think bigger on how it could benefit my team.
For example, I have set up a recurrent SQL query to get and manipulate data, format into an HTML table and email out to our group. Presently, this relies on my gateway and my Outlook account (report is emailed from me). The problem is, I am traveling a lot for work so my computer may or may not be on and logged in at the scheduled time of this trigger. When this occurs, there is a gateway error and the Flow fails. As for the email address issue, I realize this could be handled with a shared email address or by using the "Send Email Notification".
What I envision is using Flow from a shared account on a resource that is always on and connected to keep the gateway open at all times. Have any other users run into this issue? Unfortunately my IT group is not terribly familiar with Power Automate and how it works so it has been difficult to explain. As an added benefit, if this headless version of Flow were always on and connected, it could be assigned an email account that cold be used for future Power Automate flows using the Outlook connector. In this way, Flow would work more like a Service rather than per-User application.
I'd like to think I am not the first person to run into an issue such as this but I have a feeling I am not able to properly articulate it to get the information I need searching Google or the forums. I appreciate any help that can be offered here.
