Power Platform Community Forum Thread Details

Hello,

I have created a simple office script which copy value from Cell A1 to D1:

function main(workbook: ExcelScript.Workbook)

{ let list1Sheet = workbook.getWorksheet("List1");

// Get the value from List1 cell A1

let valueToCopy = list1Sheet.getRange("A1").getValue();

// Set the value in List1 cell D1

list1Sheet.getRange("D1").setValue(valueToCopy); }

This script works fine in Excel but when I used it in a flow nothing haapend. My flow:

Does anybody know what I am doing wrong?

Thanks

Categories:

Office script is not triggerd