Hello the community.
I created an excel script to clean some line from an excel file.
When I run the script in excel online, it's working perfectly well.
When I try to run it from power automate, it's not working.
My script :
This is what I get when I run it directly from excel online : i have the line colored in yellow.
But when I run it from power automate, it's only creating the filtering column on the right.
Thanks for your help.
So I have been able to go one step further.
The problem is that when we launch the script from power automate, it's not calculating the formula result correctly.
I get #VALUE! instead of the result.
You should avoid using 'relative' referencing in Office Scripts for running Power Automate
This line will not work in PA
let selectedSheet = workbook.getActiveWorksheet();
Instead you can use
let selectedSheet = workbook.getWorksheet('NAME-OF-YOUR-SHEET');
This doc explains it -
This was not the issue. But I will modify, we never know.
I finally found the problems. There was 2.
First : my excel time is still PST. It should be UTC+1 as this is what I set in my Microsoft profile. Or UTC if I read article. So I had to deal with time zone conversion with formulas. Very funny.
Second : the script runs in English for date and time format (even if I set my excel as french). So it was not translating the date correctly. I had to translate, convert with formulas.
If you're smart, not an expert and want to be effective, use Zapier. It took me 5 minutes instead of days to do what I intend to do with Zapier (getting a list of appointment from Acuity and put it in a sharepont list). I had no choice but to use Flow due to company policy but Microsoft flow and Excel Script is just for experts.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.