Power Platform Community Forum Thread Details

Hi community!

I am currently investigating an initiative which seems to be straight-forward in the beginning but the devil is in the detail I guess.

The key part of it are some calculations based on csv tables. In the optimum scenario, a model built in python could be used for the calculations. So basically a power automate cloud flow that executes a python script would be the optimum solution.

Regarding this, here are some ideas that came to my mind:

Having the excel script stored in an accessible location and let the script run via Power Automate Desktop
- The problem: We do not want to use a desktop instance and want to keep it as serverless as possible
Execute the python script directly from the cloud flow
- I guess this is not possible?
Outsourcing the python script to an azure function which is called by Power Automate
- We have not implemented such mechanism yet. Is it difficult?
Outsourcing the python script to an "azure automation"
- We have no experience here either. What would be recommended first steps?
Reducing the calculation effort by having variables set as fixed and do table calculations in power Automate
- Is Power Automate capable of doing table calculations? E.g. Sum of two columns etc?
Having the calculation simplified and in macro format and let Power Automate Cloud Flow execute the macro?
- I guess there has to be a option enabled to allow power automate to run macros?

What would your recommendation be?

Categories:

General topics