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

All responses (4)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

HI @stephenJames,

This is the flow:
stephenJames 286 on at

Like
a
(0)

Report
Copy link

Link copied!

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

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.