very good day maybe someone has an answer, I have a flow in power automatice that executes an excel script online the script is a Buscav which if I execute it from excel it works but from power automatic it doesn't, does anyone know why and if it is possible fix?
What am I looking to do?
I have two tables in excel oline (Table1 and Table5) these two tables in different sheets, I seek to bring the mail when the auxiliary is filled
script (the script works if i run it directly in excel online)
Thank you very much
Hi, I have exactly the same problem and I think that "setFormulaLocal" is causing the trouble.
If I change it to only "setFormula" inside the script, the flow in PowerAutomate works but the result is "#NAME"; I have to manually click on the formula bar and press enter (without doing anything else), and that solves the #NAME problem.
If you have found a solution I would appreciate sharing it.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.