Huh, interesting. Reminds of an "enterprise" version of Apple's Automator tool. I always wished Apple had taken the premise of Automator and blended it with the UI of Quartz Composer.
It looks like Microsoft is a few steps closer to that kind of thing with Power Automate.
I find it buggy when you’re not on the main commercial cloud. For example, simple operations related to finding unique values in Excel just don’t work.
I have it intergated with an on prem SQL server, no issues. When a new client is added to the SQL database a flow triggers, that creates Sharepoint folders with the clients info, also creates a planner tasks list for the intake process.
I also have a flow that brings the Planner tasks back into SQL so that I can dyanically create links to the Planner tasks list in the SQL database frontend.