Hi all,
I want to build a Stock Ticker using the new Stock data type in Excel. I have made good progress but i found a snag. In order to refresh the stock information you need to hit the Refresh button in excel. For this I created the file on desktop and then copied that to a folder in Sharepoint. After reading about this situation I found that you can create a script to perfom the automatic refresh. The code looks like this:
function main(workbook: ExcelScript.Workbook) {
// Your code here
let worksheet = workbook.getWorksheet("Sheet1");
workbook.refreshAllDataConnections();
worksheet.calculate
console.log("I did it")
let range = worksheet.getRange("B8");
console.log(range.getValues());
range.setFormula("=now()");
console.log(range.getValues());
}
If I run the code manually it runs with no issues whatsoever. Now I am trying to get this code to run in a flow. I created the following flow:
The flow runs without any issues as you can see below.
The issue is the data is not refreshed. Am I missing something?
Thank you in advance for any advice.
