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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.