Email attachment not opening correctly

[mwackers]

I’ve built a flow to request approvals and to attach all files from a SharePoint folder to that approval request. I think the issue is where I put the file contents in the array.

The flow is successful, but in opening the files, they fail to load.

here is array

Here is the code

{

    "inputs": {

        "name": "FileAttachmentContent",

        "value": {

            "Name": "@items('Apply_to_each_4')?['{FilenameWithExtension}']",

            "Content": "@body('Get_file_content')?['$content']"

        }

    },

    "metadata": {

        "operationMetadataId": "1fb9c83b-b301-488e-9904-0c14a746aec8"

    }

}

Here is what is in the array

here is the error when opening attachments

[CFernandes]

Hey @mwackers I assume you are attaching SharePoint files to email attachment.

If yes, It should be ContentBytes 

{
"Name": @{items('Apply_to_each')?['{FilenameWithExtension}']},
"ContentBytes": @{body('Get_file_content')?['body']}
}

For details see - https://learn.microsoft.com/en-us/microsoft-365/community/power-automate-send-sharepoint-files-as-at... 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

{
"Name": @{items('Apply_to_each')?['{FilenameWithExtension}']},
"ContentBytes": @{body('Get_file_content')?['body']}
}

[mwackers]

No luck

In testing the Content byes is a null value.

I played around with some expressions and was able to get the ContentBytes to no longer be null using outputs instead of body

But I got this "Count not find member ContentBytes"

[mwackers · Accepted solution]

After trial and error,

the following worked

"content": outputs('Get_file_content')?[body]