Hi, I have been using Power Automate for flow development for almost 6-8 months mainly for small projects. Small to medium office automation projects, adaptive cards data fetching etc .... Now there is a situation where my team is asking whether I can do more complicated SharePoint project which involves lots of mathematical calculations in backend and reports generated are critical in nature(plus additional outlook automation requirements) . My experience with Power Automate is that I prefer it for small to medium complex automation projects. I would like to know experience of Senior Power Automate developers in complex projects. Is it advisable to use Power automate for complex projects? How is your experience with debugging and later stage customer supports?
Cost for premium connector is 15$ per user who owns the flow. If you have dev, test, prod environments, then you'll need a premium account for each service account. Also you might need premium connection for developers and business owners. Just keep adding 15$ per each flow author/editor.
Now if your users trigger the flow from flow ui, then you'll also need licenses for each user running the flow I believe, because the flow contains premium connectors. But if a power app consumes flow and the users just use the power app you don't need to get licenses for your users.
My recommendation is to contact microsoft sales team to iron out all these things instead of relying on a forum.
I am not sure about budget in that case.How much additional cost does this add to project. Premium connector and HTTP calls (Say if around 100 calls per day are required)
In my opinion, power automate is for basic business flow applications. If you computationally intensive tasks, those steps cannot be done efficiently in power automate. You will most likely hit flow limits. You will have to use it in tandem with Azure functions.
So to answer your question, yes you can start using power automate and if you run into computationally intensive tasks that doesn't work for power automate, just transfer those tasks to azure functions and trigger it from within flow using HTTP Premium connector or a custom connector.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional