Action 'Run_script' Failed

[cswanson22]

Hello, I received the following error on my Run script in my flow: "We were unable to run the script. Please try again.
Office JS error: Line 5: Workbook addTable: A table can't overlap another table.
clientRequestId: 39e632d2-9e17-4eaa-b8af-c3bd0cbb115c"

My flow is pulling data and importing it into an Excel spreadsheet

Here's the output script:

{

    "host": {

        "connectionReferenceName": "shared_excelonlinebusiness",

        "operationId": "RunScriptProd"

    },

    "parameters": {

        "source": "sites/***.sharepoint.com,5a206f53-f5f0-4393-9233-f40debbcf70e,cdbf5d29-9e7d-4588-9d78-2f27cd4371b3",

        "drive": "b!U28gWvD1k0OSM_QN67z3Dildv819nohFnXgvJ81DcbOaOXofGtvgRJt8PKw3vvHQ",

        "file": "File",

        "scriptId": "ms-officescript%3A%2F%2Fonedrive_business_itemlink%2F01TE7DZHDEGE5R37SUGBA2UZBRBXRQ5MCB"

    }

}

[MichelleRanMSFT]

Hi @cswanson22 - it looks like this error is because your script tried to create a table in a range where there's already a table. Try double-checking your script and worksheet to make sure this isn't the case. If you're not able to identify the issue, though, would you be able to share your script, flow, and an example workbook (sensitive data removed as necessary) so we can try to reproduce this?

[cswanson22]

Hi MichelleRanMSFT, 

Thank you for responding. I have attached the 2 files requested. 

[MichelleRanMSFT]

Can you share your script code as well?

[cswanson22]

{

    "inputs": {

        "host": {

            "connectionName": "shared_excelonlinebusiness",

            "operationId": "RunScriptProd",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"

        },

        "parameters": {

            "source": "sites/***s.sharepoint.com,5a206f53-f5f0-4393-9233-f40debbcf70e,cdbf5d29-9e7d-4588-9d78-2f27cd4371b3",

            "drive": "b!U28gWvD1k0OSM_QN67z3Dildv819nohFnXgvJ81DcbOaOXofGtvgRJt8PKw3vvHQ",

            "file": "@variables('File_Path')",

            "scriptId": "ms-officescript%3A%2F%2Fonedrive_business_itemlink%2F01TE7DZHDEGE5R37SUGBA2UZBRBXRQ5MCB"

        },

        "authentication": "@parameters('$authentication')"

    },

    "metadata": {

        "operationMetadataId": "e1588403-58d5-4d4b-bb18-684475ba9ec7",

        "tableId": null

    }

}

[MichelleRanMSFT]

By script code, I mean the contents of the script when you open it in the Code Editor in Excel. For example:

That's the best way to help us to understand what your script does and what might be going wrong.

[cswanson22]

Sorry for the confusion and thank you for your patience

function main(workbook: ExcelScript.Workbook) {

  // This action currently can't be recorded.

  let selectedSheet = workbook.getActiveWorksheet();

  // Add a new table at range A1:AC141 on selectedSheet

  let newTable = workbook.addTable(selectedSheet.getUsedRange(), true);

  // Rename table newTable to "Charge_Data"

  newTable.setName("Charge_Data");

}

[MichelleRanMSFT · Accepted solution]

Thanks for sharing! If I'm understanding correctly, your script is trying to create a table over the used range in a worksheet, and the file/workbook is a dynamic parameter passed into the run script action?

If so, then your error is probably because you're running the script on a worksheet that already has a table somewhere. You could check this by modifying your script like so:

function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	if (selectedSheet.getTables().length > 0) {
		console.log('This worksheet already has a table. Stopping script.');
		return;
	}
	// Add a new table at range A1:AC141 on selectedSheet
	let newTable = workbook.addTable(selectedSheet.getUsedRange(), true);
	// Rename table newTable to "Charge_Data"
	newTable.setName("Charge_Data");
}

It'd also be helpful to understand how you pass the file parameter into the run script action (i.e., show the previous steps of the flow).

[cswanson22]

Try to get this part of the automation to run to update Power Bi information,

[cswanson22]

I'm new to this whole and currently learning. I'm trying to fix an issue with a recent failed flow. The information from the table is sent to Power Bi. I updated the code with your information and now getting the current error: Request to Graph was malformed
clientRequestId: f09a1d0e-879a-495f-93c6-62190dfc4dd9

I don't see this clientRequestId anywhere. Thank you and sorry if I'm being a pain in the behind.

[cswanson22]

Here is the flow and the section that is getting the error. I'm now getting 'Request to Graph was malformed
clientRequestId: 2a5a6e66-a386-47e7-9430-9a4c5cea9f83' after making the changes you sent last week. Thank you

 

 

[MichelleRanMSFT]

Could you share a screenshot of where/how this error appears?

[cswanson22]

Part of the code:

{
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"Billing Account Number": {
"type": "string"
},
"Product Family": {
"type": "string"
},
"Annotation": {
"type": "string"
},
"Charge Level": {
"type": "string"
},
"Charge Type Description": {
"type": "string"
},
"Service Line (Customer Service)": {
"type": "string"
},
"Product Line": {
"type": "string"
},
"Location A City": {
"type": "string"
},
"Location A State": {

Error:

"errors": [
{
"message": "Required properties are missing from object: Annotation, Charge Level, Charge Type Description, Service Line (Customer Service), Product Line, Location A City, Location A State, Location A Country, Location Z City, Location Z State, Location Z Country, Market/Tier Name, Rate Center, Service ID (Supporting ID), Charge Description, Additional Charge Information, Bill From Date, Bill To Date, Units, Charge Amount, Discount Amount, Tax_x003a_ Federal, Tax_x003a_ State, Tax_x003a_ City, Tax_x003a_ County, Tax_x003a_ Other, Tax_x003a_ VAT, Account Description 1, Account Description 2, Bill Invoice Number, Bill Invoice Row ID, Billing Account Number-Account Description 1-Service ID, Bus Org ID, Carrier Circuit ID, Carrier ID, Child Account, Name, Circuit ID, Circuit Information, Circuit Type, Circuit_ID_A, Circuit_ID_Z, CLIN / BPID Code, CLIN /BPID Description, CLLIA, CLLIZ, Contract Number, Customer Designated Codes, Day of Month, Day of Week, Digital Access, Disconnect Date, Discount Description, Display Account Number, Effective Date, End User, Event Date, Event Time, Hour, Install Date, Internal Account Number, Invoice Date, Invoice Section Name, IP_Address, Jurisdiction, Legacy* Circuit Id, Legacy* Circuit Term, Legacy* IP VPN PIID, Legacy* Logical Interface PIID, Legacy* Port Id, Legacy* Service End User, Legacy* Service ID, Location A, Location A Type, Location Z, Location Z Type, Managed Service Type, Member ID, Month, NPA_NXX, PIID-Product, PO Number, POP Units, Port Code, Product Account Name, Provisioning Circuit ID, PSCID - Service, Quarter, Rate, SCID-GLMPS (MM), SCID-Service, Seat Price, Seat Quantity, Section Header 2, Service Address A, Service Address B, Service Description 1, Service Description 2, Service Number, Service Order, Service Provider, Service Request, Service Type, Site Name, Site Number, Speed, Star, Subsection Header, Switch ID Location A, Switch ID Location Z, Switch Name Location A, Switch Name Location Z, Tariff/Period, Tax Included (Y/N), Tax Label, TM, TM, WEB, VDE, STAR, Annotation, Unit Number, Unit Rate, V&H Miles, VDE, Web, Week, WTN, Year.",
"lineNumber": 0,
"linePosition": 0,
"path": "[0]",

[MichelleRanMSFT]

Apologies - since this error isn't coming from the run script action, it's not exactly within my area of expertise. I'd suggest you create a separate thread for this error since (from what I understand) it's not related to your original issue.

[cswanson22]

You got me a step closer and I appreciate your support. Thank you