Unanswered

xlsx file won't open when saved to Sharepoint

(1) Share

Report

Posted on by JamesB3

I'm writing a flow to upload Excel reports I receive in Outlook to Sharepoint. The flow runs, but the final file won't open due to an issue with the file extension: "This workbook couldn't be opened because the file format may not be matching with the file extension." This seems a really common issue, but none of the solutions others have found to work are making a difference for me. The original file is definitely xlsx.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @JamesB3 ,
please in the "File Content" field try to use the following expression:
base64ToBinary(outputs('Get_Attachment_(V2)')?['body/contentBytes'])

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
JamesB3 8 on at

Like (1)

Report
Copy link

Link copied!

Sorry, that gives the same error.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @JamesB3 ,
would you please share the Get Attachments output like below?

BR,
Marco

Was this reply helpful? Yes No
JamesB3 8 on at

Like (0)

Report
Copy link

Link copied!

{
    "inputs": {
        "host": {
            "connection": {
                "name": "@parameters('$connections')['shared_office365']['connectionId']"
            }
        },
        "method": "get",
        "path": "/codeless/v1.0/me/messages/@{encodeURIComponent(triggerBody()?['id'])}/attachments/@{encodeURIComponent(items('Upload_attachment')?['id'])}",
        "queries": {
            "mailboxAddress": "blah blah blah;"
        },
        "authentication": "@parameters('$authentication')"
    },
    "metadata": {
        "operationMetadataId": "cb11cb26-d948-458c-8909-f7fa1e929440",
        "flowSystemMetadata": {
            "swaggerOperationId": "GetAttachment_V2"
        }
    }
}

Was this reply helpful? Yes No
Pablinho 6 on at

Like (0)

Report
Copy link

Link copied!

Exactly the same problem here. Anyone has any update regarding this?

Thanks!

Was this reply helpful? Yes No
Pablinho 6 on at

Like (0)

Report
Copy link

Link copied!

Hey! I was able to fix it and maybe you have the same scenario as me.
The email that you receive contains more things in it besides the attachment file? Like signature pictures and so?

My problem was that the email had a signature with a picture, which was being considered an attachment and was tried to be uploaded as excel. After I resend the email without any other file format, it works perfectly. Let me know if this solves your issue!

Best,
Pablo

Was this reply helpful? Yes No