Retriving Attachment from Encrypted email

(0) Share

Report

Posted on 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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

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
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @stephenJames,

This is the flow:

Was this reply helpful? Yes No
stephenJames 286 on at

Like (0)

Report

@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
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report

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