Save attachments from Email

[Cityenergy]

Hi Experts

I would like to save all attachments from the outlook base on the subject title.

But since the PR number is random, please advise how to input it in the "subject contains".

Thank You

[eetuRobo]

What if you used the starting two words "Purchase Requisition" in the Subject contains field? Or can there be other emails with that text that you would not want to retrieve in the flow?

If that's not specific enough and there can be emails that has "Purchase Requisition" at the subject line then I would add something to "Body contains". So if the body will always have "Purchase Requisition XXXXXX has been approved. Here is the PDF for that Purchase Requisition" then add the "has been approved. Here is the PDF for that Purchase Requisition" to the Body contains field. Then I think it should be pretty sure that it will only trigger when purchase requisition has been approved.

[Cityenergy]

Actually, the keyword is [Purchase Requisition] and [has been approved.] But i'm not sure how to input in the 'subject contains' in PAD and it will not be able to retrieve the attachments since the numbers are missing.

[eetuRobo]

Do you mean that it needs the square brackets? If so just write them in it.

Or do you mean that you want it to check that the subject line contains BOTH Purchase Requisition AND has been approved.?
If so then you either use just one and then specify the email with some other field like Body contains like I suggested. The Subject contains cant have both starting and ending as far as I know since its just a "Contains". So the contains text has to be all together.

If you really need to use the subject contains then I think you first have it check the "Purchase Requisition" and then have condition that checks if the subject ends with "has been approved" (you need to loop each email)

[VishnuReddy1997]

Hi @Cityenergy ,

If mail contain first two words Payment Requisition everytime,you can configure as shown below.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[NathanAlvares24 · Accepted solution]

Hi @Cityenergy !

Try out this flow.

Initially for the first Retrieve email messages, here is what it looks like:

I will not save the attachments initially, just retrieve those email messages with that Subject 'Purchase Requisition'

Next I use a loop for each retrieved email. In that a condition i use, expression is this:

%Contains(RetrievedEmail.Subject, 'Purchase Requisition',True) AND Contains(RetrievedEmail.Subject, 'has been approved',True)%

Since these 2 are keywords.

Then i use Crop text to get the PR Number. Trim for any whitespaces.

then again use retrieve email messages action. This is for the second one:

Here i specified in the subject field to fetch only that which matches and save the attachments to a folder. And also mark as read after doing this.

Input:

Output:

Code(Copy and paste the below code into your power automate desktop):

Outlook.Launch Instance=> OutlookInstance
Outlook.RetrieveEmailMessages.RetrieveEmails Instance: OutlookInstance Account: $'''test@hotmail.com''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: False ReadBodyAsHtml: False FromContains: $'''test@hotmail.com''' SubjectContains: $'''Purchase Requisition''' Messages=> RetrievedEmails
LOOP FOREACH RetrievedEmail IN RetrievedEmails
    IF (Contains(RetrievedEmail.Subject, 'Purchase Requisition') AND Contains(RetrievedEmail.Subject, 'has been approved')) = $'''True''' THEN
        Text.CropText.CropTextBetweenFlags Text: RetrievedEmail.Subject FromFlag: $'''Purchase Requisition''' ToFlag: $'''has been approved''' IgnoreCase: False CroppedText=> PRNumber IsFlagFound=> IsFlagFound
        Text.Trim Text: PRNumber TrimOption: Text.TrimOption.Both TrimmedText=> PRNumber
        Outlook.RetrieveEmailMessages.RetrieveEmailsAndSaveAttachments Instance: OutlookInstance Account: $'''test@hotmail.com''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: True ReadBodyAsHtml: False FromContains: $'''test@hotmail.com''' SubjectContains: $'''Purchase Requisition %PRNumber% has been approved''' SaveAttachmentsInto: $'''C:\\Users''' Messages=> RetrievedEmails2
    ELSE
        NEXT LOOP
    END
END
Outlook.Close Instance: OutlookInstance

Just replace your Attachment path and Email IDs for fields To and From in this code.

I hope this helps.

[Cityenergy]

Hi @NathanAlvares24 

My 'if' Actions have lesser statement as yours.

Are you able to advise?

Thank You

[NathanAlvares24 · Accepted solution]

Hi @Cityenergy !

In the first operand write this:

%Contains(retrievedemail.Subject, 'Purchase Requisition', True) AND Contains(retrievedemail.Subject, 'has been approved', True)%

In the second operand write this:

True

And finally in the operator dropdown, select the option: "Equal to (=)"

So therefore it will look something like this:

I hope this helps.

[Cityenergy]

Hi @NathanAlvares24 

Thank You so much!

I have retrieved the attachment successfully and also learned something new.