Getting a Corrupt file when using Power automate to pull a PDF from email

Like (0) Share

Report

Posted on 22 May 2024 18:56:14 by Jerod79

"type": "Foreach",

"foreach": "@triggerOutputs()?['body/attachments']",

"actions": {

"Get_Attachment_(V2)": {

"type": "OpenApiConnection",

"inputs": {

"parameters": {

"messageId": "@triggerOutputs()?['body/id']",

"attachmentId": "@items('Apply_to_each')?['id']"

"host": {

"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",

"connection": "shared_office365",

"operationId": "GetAttachment_V2"

}

"metadata": {

"operationMetadataId": "1c723f92-22fd-4cd4-bf74-961b75b534aa"

}

"runAfter": {

"Set_variable": [

"Succeeded"

]

"metadata": {

"operationMetadataId": "9933e8d9-c0c9-434f-be56-4a7225a3972d"

When I set my flow to pull a PDF from an email, the flow works and gets the item to my sharepoint, but it is corrupted and cannot be seen or used in Power BI. HELP Please. I am learning Power Apps now, 45 and an Old Army Grunt learning. Thanks in advance

All responses (5)

Answers (0)

creativeopinion 10,419 Super User 2025 Season 1 on 22 May 2024 at 22:00:07

Like (0)

Report

Re: Getting a Corrupt file when using Power automate to pull a PDF from email

@Jerod79 No worries. You can remove these two actions.

Confirming that the condition is set up correctly. You're confirming to see if the name of the attachment is empty?..
Jerod79 4 on 22 May 2024 at 19:22:59

Like (0)

Report

Re: Getting a Corrupt file when using Power automate to pull a PDF from email

Honestly I cannot explain anything. I am trying to learn and someone in my Progress team gave me a flow to use
creativeopinion 10,419 Super User 2025 Season 1 on 22 May 2024 at 19:12:19

Like (0)

Report

Re: Getting a Corrupt file when using Power automate to pull a PDF from email

@Jerod79 Can you explain the purpose of initializing and setting the variable at the start of your flow? If you are using it to output the Subject line of the email—may I suggest a Compose action instead.

Can you try running a test again with your flow in the Classic Designer? It looks correct to me. The New Designer is a bit buggy. If that doesn't work can you try to create a new flow and toggle of the new designer before making any edits to it. Also, ensure that Include Attachments in the When a new email arrives (V3) trigger is set to Yes.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram
Jerod79 4 on 22 May 2024 at 19:04:13

Like (0)

Report

Re: Getting a Corrupt file when using Power automate to pull a PDF from email
creativeopinion 10,419 Super User 2025 Season 1 on 22 May 2024 at 19:02:27

Like (0)

Report

Re: Getting a Corrupt file when using Power automate to pull a PDF from email

@Jerod79 Can you share a screenshot of your full flow? If you are using the New Designer toggle it off. Click on all actions to expand them. Ensure your flow is in edit mode.

In the meantime, you might find this YT Tutorial helpful:

Save Email Attachments to SharePoint with Microsoft Power Automate

Power Automate doesn’t have a download attachment from outlook action. In this Power Automate Video tutorial, I’ll show you how to use the Get Attachment (V2) action in combination with the Create File action to get your email attachments onto SharePoint.

The Create File action will overwrite any files that already exist with the same name. In this tutorial, I’ll show you how you can append a timestamp to the end of a file name to prevent your file from being overwritten.

I’ll also show you how to set up your flow so that you can trigger it manually while building it so you don’t need to wait for an email to arrive. At the end of the video I’ll show you how adding trigger conditions to your flow can prevent it from triggering if certain conditions aren’t met. Although the final flow uses the When a new email arrives in a shared mailbox (V2) trigger, you can use any of the When a new email arrives triggers for your flow. Adjust this flow to suit your needs!

IN THIS VIDEO:

✅ How to Automate Downloading and Uploading Email Attachments to SharePoint

✅ How to Use a the Get Email (V2) action

✅ How to Use the Get Attachment (V2) action

✅ How to Create Attachment Files using the Create File Action

✅ How to Prevent the Create File Action from Overwriting a File

✅ How to use Split the Filename from its Extension

✅ How to Append a Timestamp to a File Name

✅ How to use the When a New Email Arrives in a Shared Mailbox (V2) trigger

✅ How to use the Convert Time Zone action

✅ How to add Trigger Conditions to your Flow

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram