Get Text File Attachment Content from Shared Mailbox Email

[PhilFancy]

I am struggling with this:

Shared Mailbox receives mails with text files (.txt) attached. The flow should start and get the text file content as plain text. 

The flow starts with "when a new email arrives in a shared mailbox". This works as expected. 

But I struggle to get the file content of the attachments. I never ever get them as plain text. I just get them kind of encrypted (see yellow marked area - this should be just some numbers in the text file).

Tried to use a second step to get the email attachment with the same result. 

Tried to create a SharePoint file with the attachment file content from mail with the same result.

Is it possible to get the content of a text file from email attachment?

Thanks!

[MarconettiMarco · Accepted solution]

Hello @PhilFancy ,

please, after adding the "Get Attachment (V2)" action, add a "Compose" action in which put the following expression:

decodeBase64(outputs('Get_Attachment_(V2)')?['body/contentBytes'])

You'll get the txt content, like below:

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

BR,

Marco

[PhilFancy]

Works like a charm - the decodeBase64 step solved the issue. Thank you Marco!