web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate outlook actions

Power Automate

Answered

outlook actions

(1) Share

Report

Report

Posted on by Maverick79

Hello,

I created a process that saves email attachments to a network folder and moves email to archive folder. It's currently looking for unread emails, from a specific sender, and subject line test.

Current process:

launch outlook \\ retrieve email messages from Outlook \\ Process email messages in Outlook \\ Close outlook

Can someone help me add a file name and file type extension logic to the process? So look for file name = Audit and file extension = .xlsx

Any help or direction would be greatly appreciated.

Thanks,

Tim

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Maverick79
You can apply filter condition based on subject line but You cannot directly filter attachments in Outlook. However, once all attachments are saved, you can use the "Get files from folder" action to list all files in the attachment folder. You can then apply filters based on file names and extensions, and delete any files that do not meet the criteria.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Maverick79 !

Try this flow:

Input:

Output:

After sometime it will appear in the Archive folder.

Code (just copy-paste into your flow)(Please put the necessary paths of your folder like Network folder. I just added folder name as 'Network'):

Outlook.Launch Instance=> OutlookInstance Outlook.RetrieveEmailMessages.RetrieveEmailsAndSaveAttachments Instance: OutlookInstance Account: $'''nathanlalvares@hotmail.com''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: False ReadBodyAsHtml: False FromContains: $'''username@hotmail.com''' SubjectContains: $'''test''' SaveAttachmentsInto: $'''C:\\Users\\UserName\\Desktop\\Network''' Messages=> RetrievedEmails LOOP FOREACH RetrievedEmail IN RetrievedEmails LOOP FOREACH Attachment IN RetrievedEmail.Attachments IF (Attachment.NameWithoutExtension = 'Audit' AND Attachment.Extension = '.xlsx') = $'''True''' THEN Outlook.ProcessEmailMessages.MoveEmails Instance: OutlookInstance Account: $'''username@hotmail.com''' EmailsToProcess: RetrievedEmail MailFolder: $'''Archieve''' ELSE File.Delete Files: Attachment END END END Outlook.Close Instance: OutlookInstance

I hope this helps.

Was this reply helpful? Yes No

Join the conversation