Saving Email Attachments to Network Drive

(0) Share

Report

Posted on by AD-08121618-0

Hello,

I'm attempting to build a flow that retrieves an Excel file attached to a regularly scheduled email and saves it to a network drive. I've already installed a personal data gateway. When the flow runs, it creates a 1 KB file that, when opened, presents a format/extension error. I'm assuming this must have something to do with encoding the file, as the same flow works perfectly when retrieving attachments and saving them to SharePoint or OneDrive. The flow itself is extremely simple and all settings are correct inside the trigger insofar as attachments are being passed to the next step. Any help would be appreciated.

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Saving Email Attachments to Network Drive

Shouldn't that say "Attachment name"?

Can you please share the output of the trigger

Was this reply helpful? Yes No
AD-08121618-0 2 on at

Like (0)

Report
Saving Email Attachments to Network Drive

@SudeepGhatakNZ

I've updated the File Name to Attachments Name, but would that have any bearing on the results? That's just what I want to name the file, correct?

Here's the output of the trigger from the flow -

{

"Cache-Control": "no-store, no-cache",

"Pragma": "no-cache",

"Transfer-Encoding": "chunked",

"Location": "https://flow-apim-msmanaged-na-westus2-01.azure-apim.net/apim/office365/cf2fc1286b274a078a2a217b66bd8608/v3/Mail/OnNewEmail?folderPath=Id%3a%3aAAMkADk5OTViMWQ0LTU3NjQtNDMzZC1hODBiLWI4OWY1M2E1OWFlNgAuAAAAAAACwYBNcllkQIBh1mVPMyrjAQBcw-niBj9ST7UwZKMyyZ1yAAIk-rQ1AAA%3d&fetchOnlyWithAttachment=true&subjectFilter=Finance+RY&LastPollInformation=eyJMYXN0UmVjZWl2ZWRNYWlsVGltZSI6IjIwMjQtMTItMDhUMTM6MzM6MTkrMDA6MDAiLCJMYXN0Q3JlYXRlZE1haWxUaW1lIjoiMjAyNC0xMi0wOFQxMzo1MDo1MiswMDowMCIsIkxhc3RNZXNzYWdlSWQiOiJBQU1rQURrNU9UVmlNV1EwTFRVM05qUXRORE16WkMxaE9EQmlMV0k0T1dZMU0yRTFPV0ZsTmdCR0FBQUFBQUFDd1lCTmNsbGtRSUJoMW1WUE15cmpCd0Jjdy1uaUJqOVNUN1V3WktNeXlaMXlBQUlrLXJRMUFBQmN3LW5pQmo5U1Q3VXdaS015eVoxeUFBSk1vemtoQUFBPSIsIkxhc3RJbnRlcm5ldE1lc3NhZ2VJZCI6IjwyNDE4OC4wLjc4Njk3OTk4MDYzNkBXQTAxODk0UC5vbmVhYmJvdHQuY29tPiJ9",

"Retry-After": "3600",

"Vary": "Accept-Encoding",

"Set-Cookie": "ARRAffinity=ef60c7efc411e7a2234239102c2b4e8d94db8fa5e2ba182ac3091a4caeeeaf0b;Path=/;HttpOnly;Secure;Domain=office365-cus.azconn-cus-001.p.azurewebsites.net,ARRAffinitySameSite=ef60c7efc411e7a2234239102c2b4e8d94db8fa5e2ba182ac3091a4caeeeaf0b;Path=/;HttpOnly;SameSite=None;Secure;Domain=office365-cus.azconn-cus-001.p.azurewebsites.net",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"x-ms-request-id": "96d08ab9-f21a-40b6-bdaf-727888a2ab99;0624116e-c477-4a1e-8c52-9fab683f1670",

"X-Content-Type-Options": "nosniff",

"X-Frame-Options": "DENY",

"x-ms-environment-id": "default-5b268d57-2a6f-4e04-b0de-6938583d5ebc",

"x-ms-tenant-id": "5b268d57-2a6f-4e04-b0de-6938583d5ebc",

"x-ms-dlp-re": "-|-|-",

"x-ms-dlp-gu": "-|-",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"x-ms-apihub-obo": "false",

"Date": "Sun, 08 Dec 2024 13:51:17 GMT",

"Content-Type": "application/json; charset=utf-8",

"Content-Length": "1125",

"Expires": "-1"

}

{

"id": "AAMkADk5OTViMWQ0LTU3NjQtNDMzZC1hODBiLWI4OWY1M2E1OWFlNgBGAAAAAAACwYBNcllkQIBh1mVPMyrjBwBcw-niBj9ST7UwZKMyyZ1yAAIk-rQ1AABcw-niBj9ST7UwZKMyyZ1yAAJMozkhAAA=",

"receivedDateTime": "2024-12-08T13:33:19+00:00",

"hasAttachments": true,

"internetMessageId": "<24188.0.786979980636@WA01894P.oneabbott.com>",

"subject": "Finance RY",

"bodyPreview": "",

"importance": "normal",

"conversationId": "AAQkADk5OTViMWQ0LTU3NjQtNDMzZC1hODBiLWI4OWY1M2E1OWFlNgAQAC5JNnIG3SlNiK02QVIliC4=",

"isRead": true,

"isHtml": false,

"body": "\r\n",

"from": "adam.dyas@abbott.com",

"toRecipients": "adam.dyas@abbott.com",

"attachments": [

{

"@odata.type": "#microsoft.graph.fileAttachment",

"id": "AAMkADk5OTViMWQ0LTU3NjQtNDMzZC1hODBiLWI4OWY1M2E1OWFlNgBGAAAAAAACwYBNcllkQIBh1mVPMyrjBwBcw-niBj9ST7UwZKMyyZ1yAAIk-rQ1AABcw-niBj9ST7UwZKMyyZ1yAAJMozkhAAABEgAQANryoiTBe89BooikjbGBSjo=",

"lastModifiedDateTime": "2024-12-08T13:50:58+00:00",

"name": "Finished Goods Projected Inventory Report(Finance)_49_7932221997312924214.xlsx",

"contentType": "application/octet-stream",

"size": 2766035,

"isInline": false

}

]

}

Was this reply helpful? Yes No