Power Automate · Attachment Not Opening

[momureithi]

Hello,

I'm experiencing a problem where the attachment sent out with the approval notification is not opening. On the flow, I have used the "Get attachments" from SharePoint connector.

When the approval request notification is sent out to the approver on email, they are able to open the attachment.

What could be the problem?

Thanks.

[manuelstgomes]

Hi @momureithi 

Please check that you're sending the attachment contents when sending the email. If you're doing this can you please share the section of the Power Automate that is failing and the error so that I try to help you?

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

Cheers
Manuel

[CFernandes]

Howdy @momureithi 

"Get attachments" will not return the file content, you need to use the SharePoint 'Get File Content" to get the File content, and then pass "File Content" to Send an email action from a high level your Flow should look like below.

I hope this helps.

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!

[momureithi]

Howdy @CFernandes,

This is my current set up. Does it look good or should I switch it up to match your illustration?

Please let me know.

[CFernandes]

Howdy @momureithi 

The problem with your Power Automate solution is that you are creating the File array incorrectly.

The Correct format should be 

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

Complete solution:

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!

[CFernandes · Accepted solution]

Howdy,

I think the problem is with with Append Array.

It should be in format:

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

Complete solution:

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!

[momureithi]

Many thanks, @CFernandes! Worked like a charm. 👍

I, however, encountered the error below during the flow run (are you able to establish why?) :

Fixed it by encoding the file content to base64 (not sure if it's a recommended approach?) :

{
"Name": @{items('Apply_to_each')?['DisplayName']},
"Content": @{base64(body('Get_file_content'))}
}

[momureithi]

Complete solution:

[CFernandes]

Err.. I assume you stumbled over a known bug. I have stumbled on this before.

 Approvals action does not recognize contentbytes and so you need to use the content key to pass the file content. 

[momureithi]

Well understood - thank you.

[CFernandes]

Perfect. If my replied 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.

[zoecooper]

Hi CFernandes, I am having the same problem and tried following the above except I need to get the attachments from a SP folder not a SP list. I don't know what to put for the list field in the 'Get attachments' action. Could you assist?

[zoecooper]

Hi again, here are photos of my flow:

I tried using get files instead of get attachments because I have a SP folder not a SP list I think.

[william-yan]

In Append to array variable 2 action, I just change Content instead of ContentBytes, then it work.

for example:

{
"Name": @{items('Apply_to_each_3')['name']},
"Content": @{body('Get_file_content_using_path')}
}