Copy the result of an online excel formula to SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi. I have a flow in Power Automate that uses Excel Online to perform a date calculation. To execute that formula I use a script that is also part of the flow. It happens that when the script is executed, the value that remains in the cell is "#¿NOMBRE?" but it does not reflect the date it has calculated (cell E16). When I update the cell manually, the date value does appear (cell E15).

So when I want to copy to a SharePoint list the value calculated by the Excel formula, it does not bring me the value, it just remains empty, as seen below.

Imagen de fechas1.PNG
I appreciate if someone knows how to automatically refresh the excel formula, because in the script I included a line that does it, but it generates the same result. The part of the code is as follows:

selectedSheet.getRange("E11").autoFill();

Categories:

General topics

All responses (1)

Answers (0)

jedunn 123 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I believe the autoFill() method in your Office Script is missing a couple parameters, the destination range and the auto fill type. You can read more about it here --> Range autoFill member. Alternatively, try recording a few scripts with different autofill behaviors and look at the code generated to get a sense of these parameters.