Trigger as follows.
Sharepoint File is created, (Properties only)
int var ....... ad nausum
Then check if "List" field DFT Status is in "Ready"
Not "Ready", bail (Set error codes)
True, (Was try script)
now
True, (just continue)
At first, I thought it was cranky about the workbook id, but I am asking to run a script from a library.
Offending script attached. (No secret code)
[------------ Script begin ----------]
{"version":"0.3.0","body":"// Robins Updated Script Code\n\nfunction main(workbook: ExcelScript.Workbook) {\n // Get the active cell and worksheet.\n // let selectedCell = workbook.getActiveCell();\n let selectedSheet = workbook.getActiveWorksheet();\n // CellA1 = Client\n let ClientA1 = selectedSheet.getRange(\"A1\").getText();\n // CellC1 = Date\n let DateC1 = selectedSheet.getRange(\"C1\").getText();\n // CellE1 = Ticket #\n let TicketE1 = selectedSheet.getRange(\"E1\").getText();\n // CellB3 = Employee Name\n let EmployeeB3 = selectedSheet.getRange(\"B3\").getText();\n // CellB6 = Project Manager\n let ProjectMB6 = selectedSheet.getRange(\"B6\").getText();\n // CellE3 = SA Project Number\n let SAPNE3 = selectedSheet.getRange(\"E3\").getText();\n // CellE6 WA Number\n let WANE6 = selectedSheet.getRange(\"E6\").getText();\n\n // Robin: Format as JSON and output\n\n return {\n Client: ClientA1,\n Date: DateC1,\n TicketNo: TicketE1,\n EmployeeName: EmployeeB3,\n PM: ProjectMB6,\n SAProjectNo: SAPNE3,\n WANo: WANE6\n };\n}","description":"Pull Basic DFT Info Out","noCodeMetadata":null,"parameterInfo":"{\"version\":1,\"originalParameterOrder\":[],\"parameterSchema\":{\"type\":\"object\",\"default\":{},\"x-ms-visibility\":\"internal\"},\"returnSchema\":{\"type\":\"object\",\"properties\":{\"result\":{\"type\":\"object\",\"properties\":{\"Client\":{\"type\":\"string\"},\"Date\":{\"type\":\"string\"},\"TicketNo\":{\"type\":\"string\"},\"EmployeeName\":{\"type\":\"string\"},\"PM\":{\"type\":\"string\"},\"SAProjectNo\":{\"type\":\"string\"},\"WANo\":{\"type\":\"string\"}}}}},\"signature\":{\"comment\":\"\",\"parameters\":[{\"name\":\"workbook\",\"comment\":\"\"}]}}","apiInfo":"{\"variant\":\"synchronous\",\"variantVersion\":2}"}
[-------------End script-----------]
