Help Running Office script on Sharepoint List attachment

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

Hello All,

I am trying to run an office script on a sharepoint list item. But unfortunately the Run Script connector is not able to find the file and is giving me this following error :

Here is the flow that i have setup. Quick context of what the flow does:

Whenever a new item is created the flow runs and looks if any of the added attachments has "Import_Template" as a file name
If the above value returns true then it needs to run an Office script (this is where the issues is)

MS Flow Screenshot

Can someone please tell me what i am doing incorrectly ?

PS: I am new to MS flow 🙂

Thanks !!!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Ethan313 4 on at

Like (0)

Report

Office Scripts only works for Microsoft Excel, not Microsoft Lists.

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Yes I understand that. I am extracting an excel file attached in MS list and trying to run office script attached to the excel file- Could you please tell me if that is not supported .... Do i have to copy the file to another library, run the script and re add the excel file to the SharePoint List item ? (I did not want to go this route since it might take longer time to run the flow)

Was this reply helpful? Yes No
Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Answer by Geoffren
Sharepoint list attachments are not supported with any of the ExcelOnline Business connectors.

This is a workaround that will allow you to read from the attachment (basically the workaround is to automatically copy the excel attachment into your onedrive, read it there, then delete the file). This won't work if you want to make changes to the excel attachment though...

Was this reply helpful? Yes No