I am using the "Run Python Script" action in Power Automate to execute a Python script that works perfectly outside Power Automate (tested locally without errors). However, when I attach the same script in Power Automate, it shows a "syntax error" without specifying the exact issue.
The script includes imports (re
, pandas
, datetime
, os
), file I/O operations, regex parsing, and Excel file creation using pandas
with openpyxl
. I suspect the issue might be related to environment restrictions, Python version compatibility, or dependency support in Power Automate.
Has anyone faced this issue? How did you resolve it? Are there specific requirements or limitations for running Python scripts in Power Automate that I should be aware of?
Thank you for your insights!