Take attachments from Office 365 Outlook email and store in Azure Blob Storage

Question

Take attachments from Office 365 Outlook email and store in Azure Blob Storage

Richard Jackson 91

Hi there,

I'm trying to make a Logic Apps flow which:

When a new email with attachments arrives
For each attachment
Create blob of that attachment's contents

The problem I have is the Blob Content - when using "Current Item" from the For control object I only receive the meta data about the object, not the file's contents. Could someone please let me know how I can store the actual contents?

User's image

Sample output (i.e. the contents of the newly created blob):

{"@odata.type":"#Microsoft.OutlookServices.FileAttachment","Id":"AAMkADJmMzRlYmUyLWM4OGUtNDkyNC1iNzM3LTg3NTI5YThlMTJjYgBGAAAAAAC_i6Z5MgMfTqLAVHab56vdBwC9etYtUoUmQbXuGyX2YJ4VAAAAAAEMAAC9etYtUoUmQbXuGyX2YJ4VAAG6P0RHAAABEgAQAHEzH0vh9ktHu699h-lsLcc=","LastModifiedDateTime":"2024-05-08T14:31:59+00:00","Name":"Invoice-Sound-Engineering-JJ120.pdf","ContentType":"application/pdf","Size":55347,"IsInline":false,"ContentBytes":null}

TIA!

Accepted answer

0 additional answers

Your answer

Answer 1

MayankBargali-MSFT 70,941 Moderator

@Richard Jackson Thanks for reaching out.

When you are using When a new email arrives (v3) action you can use the below configuration and in case if you are using different trigger then please let me know.

I see that you have used the current item of the for loop, but you should use the Attachment Content.

For each loop you should use the Attachments and make sure you have selected Yes to Include the attachments.

User's image

In case you are in general designer view:

User's image

In case if you need any assistance then please let me know.

Please click on ''Yes" if it helped so that it can help others in the community looking for help on similar topics.

Richard Jackson 91 Reputation points

2024-05-09T08:49:02.88+00:00
Thank you! I've run into issues with this approach:

Using the "Create blob (V2)" action, when I enter the value "Blob name" of "Dynamic content>Attachments Name", two nested "For each" controls are created. For the "Select An Output From Previous Steps" field, the outer For each uses "value", the inner For each uses "Attachments":

When running this, the first For each (which uses "value") errors, with the below:

{"code":"InvalidTemplate","message":"Unable to process template language expressions for action 'For_each_1' at line '0' and column '0': 'The template language expression 'triggerBody()['value']' cannot be evaluated because property 'value' doesn't exist, available properties are 'Id, DateTimeReceived, HasAttachment, InternetMessageId, Subject, BodyPreview, Importance, ConversationId, IsRead, IsHtml, Body, From, To, Cc, Bcc, ReplyTo, Attachments'. Please see https://aka.ms/logicexpressions for usage details.'."}

This implies there is an issue with the auto-created "value" for each loop. I can't remove this loop without deleting the "Create blob (V2)" action, and so am unable to proceed.

Would you be able to provide any guidance please?

Thanks for your help!!

Rich
MayankBargali-MSFT 70,941 Reputation points Moderator

2024-05-10T13:43:07.7866667+00:00

@Richard Jackson Thanks for your response. Looks like you are using the standard logic app and I do see the same behavior at my end. As the trigger has split on property so it is creating two loops. I will file a bug from the portal for the team to review it further.

As a workaround you can either fallback to legacy designer follow this link or refer to the below gif to move the for each action outside the for each 1 action, delete the for each 1 action and validate all the parameter are set correctly as I shared previously, or you can set the same as per the gif.

Output Successful:

Let me know if you are still facing the issue.
Richard Jackson 91 Reputation points

2024-05-10T16:10:43.9066667+00:00

@MayankBargali-MSFT Hi - that fix, following your exact GIF instructions, has worked for me! Thank you so much!

Please do report that bug and, if possible, keep me updated.

Thanks again!
MayankBargali-MSFT 70,941 Reputation points Moderator

2024-05-13T05:26:28.8166667+00:00

@Richard Jackson Thanks for your response and glad to know that you were able to resolve the issue with the workaround. The issue can be tracked here.

Share via

Take attachments from Office 365 Outlook email and store in Azure Blob Storage

0 additional answers

Your answer