
We are currently still running 8.2 On Prem, but in the next year or so we'll be moving to D365 Online. We depend heavily on SSIS (with CozyRoc add-in) and the SDK to work with our D365 environment, but moving online I'm confused on how we can use Power Automate. I thought it might replace some of our current processes, but other than basic Workflows I don't see that it's capable of doing complex processes -- or at least not easily. Is it possible to use the SDK with Power Automate? Even On Prem we can create Workflow assemblies using the SDK where the Workflow app in CRM just won't do it.
So will we be destined to continue using SSIS/CozyRoc even when we go online??? Or am I missing something with Power Automate? Using just the Web API for D365 just seems so cumbersome and limiting...
Thanks for any insight.