Retriving Attachment from Encrypted email

Like (0) Share

Report

Posted on 26 May 2022 18:44:57 by stephenJames

286

Hello,

I get an encrypted email through outlook every 2 weeks that contains a single excel document. I have tried to create a flow that monitors the inbox for emails with specific subject titles , grabs the excel attachment and saves it to a OneDrive folder. But after following a couple of guides i get error messages like

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')' is of type 'Object'. The result must be a valid array.

Has anyone successfully been able to do this and wouldn't mind pointing me in the right direction?

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 31 May 2022 at 08:10:58

Like (1)

Report

Re: Retriving Attachment from Encrypted email

Hi @stephenJames ,

Here is the thing, the RPMSG file is a protected email message file created by Microsoft Outlook, Microsoft's email and calendar application.

It contains an email that has been encrypted such that only certain users can view, print, copy, or forward the email. RPMSG files are sent as attachments to standard email messages, these attachments use the filename as message.rpmsg.

Power Automate does not support related actions to parse encrypted email, so I am afraid that Power Automate could only return message.rpmsg file name if you receive an encrypted email.

Was this reply helpful? Yes No
stephenJames 286 on 31 May 2022 at 07:45:32

Like (0)

Report

Re: Retriving Attachment from Encrypted email

@v-qiaqi-msft
Mine fails to work as yours shows.
Here is my flow

When it runs it outputs

The file in that test was a dummy txt file. But no matter what attachment is in the encrypted email it always returns the same message_v2.rpmsg file.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on 30 May 2022 at 08:07:00

Like (0)

Report

Re: Retriving Attachment from Encrypted email

HI @stephenJames,

This is the flow:

Was this reply helpful? Yes No
Rhiassuring 8,688 Moderator on 26 May 2022 at 22:38:15

Like (0)

Report

Re: Retriving Attachment from Encrypted email

Are you able to show us screenshots of how your flow is set-up, as well as screenshots of the details of the trigger output (go into a flow that has run, and show the outputs in the top action, in the attachments section) where an email has come through?

Was this reply helpful? Yes No