Unanswered

Flow can't create a connection with Excel

(0) Share

Report

Posted on by Abba

I'm trying to create a flow that makes a file based on an email attachment, but the script for the flow isn't running correctly.
Here's the whole flow:

And this is the code fore the script if it's relevant:

function main(workbook: ExcelScript.Workbook, 
TableName: string = "Table1",
SheetName: string = "Sheet1"
) {
 // Get the worksheet by name
 const selectedSheet = workbook.getWorksheet(SheetName);
 // Create a table using the data range.
 let newTable = workbook.addTable(selectedSheet.getUsedRange(), true);
 newTable.setName(TableName);}

The error kickback reads:

We were unable to run the script. Please try again.
The script couldn't create a connection with Excel. Please try again.
clientRequestId: 55e50ca3-4761-4f64-9957-31a80ee13ad5

I'm pretty new to this so any help would be appreciated! Thanks!

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@Abba Please refer this: https://powerusers.microsoft.com/t5/Building-Flows/The-script-couldn-t-create-a-connection-with-Excel/td-p/838665

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Abba 13 on at

Like (0)

Report

@ssankesh I saw this solution while looking, but our team Sharepoint doesn't require checking files in or out.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@Abba Try adding a delay before 'run script' action.

Was this reply helpful? Yes No
Abba 13 on at

Like (0)

Report

@Ankesh_49 I tried adding a few different delays up to one minute, but the flow keeps erroring out at the script step after a few seconds.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@Abba Could you please try using 'Get file properties' action between 'create file' and 'Run script' and see it it works

Was this reply helpful? Yes No
Abba 13 on at

Like (0)

Report

Same error 😕

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

Dynamic content used in File in run script?

Was this reply helpful? Yes No
Abba 13 on at

Like (0)

Report

I don't believe so. The flow is creating a new file to run the script in.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

No no. What the point I am trying to make is:
'item id' from create file action should be used in ' get file properties' action and output from 'get file properties' should be used in File in 'run script' action

Was this reply helpful? Yes No
Abba 13 on at

Like (0)

Report

Apologies. I tried that, but the flow ended up timing out. However, I didn't have an option for outputs in the run script section so that might have affected the result. Here's how my flow looks now

Was this reply helpful? Yes No