Aug 08 2022 11:59 AM
Aug 08 2022 11:59 AM
I have a power automate flow that loads a SharePoint list and creates an attachment that is an xlsx file. I grab the original file from onedrive and rename by putting the customer name in from of the file name. When I try to open the attachment, it tells me that the workbook cannot be opened. Any ideas of what is causing this? I have done similar flows in the past, but those were with docx files.
Aug 09 2022 01:02 AM
@rbutgins21 Can you show us how you configured power automate flow to create a excel file as attachment to list item?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Aug 09 2022 08:35 AM
I dont think its just your flow causing the issue - we have a list with excel attatchments, that open fine. If we create a new list item manually and attach an excel file, it wont open the file when selecting the attachment, it will if the excel file is an older format, so XLS etc.
This litterally stopped working 2 days ago.
Aug 09 2022 09:35 AM
I have the same problem and situation since 2 days ago, I had to create a column to store the Link (full URI) of the file in order to open it. It worked, but it is not a solution.
Aug 09 2022 04:41 PM
Seems it’s a Microsoft issue, which they applied a fix that didn’t work, and so are still working on it.
Oct 19 2022 01:33 AM
Oct 27 2022 01:07 AM
@MZgheib for me it worked when i put the code below for contentbytes in the add attachement to sharepoint element function.
hope it works for you too.
Nov 07 2022 05:14 AM
@AlessioCecchin thanks for the reply, i don't have content type since i am not using get content from onedrive or sharepoint, instead i am using the manual trigger to upload files and then add these files to sharepoint item as attachments. Anyway eventually i had to change my flow's concept since dealing with attachments is very limited and requires lot of work compared to saving files directly to sharepoint folder.