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

(0) Share

Report

Posted on by zz123ff

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

kinuasa 795 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No
zz123ff 30 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

kinuasa 795 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No
zz123ff 30 on at

Like (0)

Report

Hi kinuasa

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

Was this reply helpful? Yes No