How to get excel data from outlook email attachment on desktop power automatic

(0) Share

Report

Posted on by zz123ff

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

kinuasa 803 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
Power Automate for desktop retrieves messages with the 'Launch Outlook' action and the 'Retrieve email messages from Outlook' action.
As the 'Retrieve email messages from Outlook' action allows you to save attachments, I suggest that you save the files together in a specified folder and then process only the Excel files with the 'Get files in folder' action.

Regards,
kinuasa

The code below is a sample flow, which you can copy and paste into flow designer.
SET AttachmentsFolderPath TO $'''C:\\Test\\Saved\\''' Outlook.Launch Instance=> OutlookInstance Outlook.RetrieveEmailMessages.RetrieveEmailsAndSaveAttachments Instance: OutlookInstance Account: $'''MyAccount''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: False SaveAttachmentsInto: AttachmentsFolderPath Messages=> RetrievedEmails Folder.GetFiles Folder: AttachmentsFolderPath FileFilter: $'''*xls*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
zz123ff 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi kinuasa,
Thank you for the answer.

But in 'Retrieve email messages from Outlook' ,save attachment at bottom,
it seems can't change the attachment name, is it only for the path?

How can I change the saved file's name if I don't know it's original name in the email.
Verified answer

kinuasa 803 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
How can I change the saved file's name if I don't know it's original name in the email.
Each file can be renamed using the "For each" and "Rename file" actions.

The code below is a sample flow:
Outlook.Launch Instance=> OutlookInstance Outlook.RetrieveEmailMessages.RetrieveEmailsAndSaveAttachments Instance: OutlookInstance Account: $'''MyAccount''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: False SaveAttachmentsInto: $'''C:\\Test\\Saved''' Messages=> RetrievedEmails LOOP FOREACH RetrievedEmail IN RetrievedEmails IF RetrievedEmail.Attachments.Count > 0 THEN LOOP FOREACH Attachment IN RetrievedEmail.Attachments IF Contains(Attachment.Extension.ToLower, $'''xls''', False) THEN File.RenameFiles.Rename Files: Attachment NewName: $'''MYFILE_%Attachment.NameWithoutExtension%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles END END END END
zz123ff 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi kinuasa

According to your instructions, the file name changed successfully.
助けていただきありがとうございます‼