cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gilgamesh
New Member

Problem when specifying Excel file in Execute Office Scripts action

Hello everyone, I'm trying to run a flow with Office Scripts on Excel file red from Sharepoint document library.

Office Script works perfectly when I manually execute it on static Excel file.

However, when I set a dynamic file value from sharepoint library, I get 404 error such:

"The script could not be executed. Please try again. The script was unable to create a connection with Excel. Please try again"

(error message translated from italian...).

Flow extract follows:

Gilgamesh_1-1602258951270.png

 

I've tried Name, DisplayName, Id and more, but nothing seems to work.

Thank you for any help!

 

PS. my flow works with no errors when I remove "Execute script" action... 😏

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks for answer @Yutao , I get the result adding an action between "Create file" on Sharepoint and "Run script": choosing "Get file properties" I used the item "Identifier". It worked for me!

 
 
 
 
 

6VKFty7fDK.png

 

 

View solution in original post

2 REPLIES 2
Yutao
Microsoft
Microsoft

Hi @Gilgamesh ,

 

"Id" seems to be working for me.

Yutao_0-1602262296008.png

 

If it still doesn't work for you, could you please share (or PM me) the "x-ms-client-request-id" from the error output?

 

Thanks!

Yutao

Thanks for answer @Yutao , I get the result adding an action between "Create file" on Sharepoint and "Run script": choosing "Get file properties" I used the item "Identifier". It worked for me!

 
 
 
 
 

6VKFty7fDK.png

 

 

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (58,973)