cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Retrieve data from attachment

Hi everyone, I want to retrieve the attachment (xlxs) when a specific email hits my Inbox. I tried >launch Outlook >retrieve mail. But it isn't working.  Can someone help?

 

**The intend is to get  range of data for the attachment

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Hi there, 

 

In case you use Outlook, you could consider using the action under Outlook -> Retrieve email messages from Outlook. This action, among others, offers the ability to select whether you want the attachments saved. 

By selecting the option "Save Attachment", another field will show up asking for the extraction path. 

You may then use this path to access the excel file using all the given actions you will find under the Excel actions folder.

 

Thank you for providing your feedback. Please let me know in case this works for you 🙂

 

Georg

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

Hi there, 

 

In case you use Outlook, you could consider using the action under Outlook -> Retrieve email messages from Outlook. This action, among others, offers the ability to select whether you want the attachments saved. 

By selecting the option "Save Attachment", another field will show up asking for the extraction path. 

You may then use this path to access the excel file using all the given actions you will find under the Excel actions folder.

 

Thank you for providing your feedback. Please let me know in case this works for you 🙂

 

Georg

View solution in original post

Thanks worked like a charm. 

Hi Georg,

Is there any way to filter the attachments for just xlsx files for example?

I get a lot of jpg signature images etc that I do not want to save.

 

In PA, I would set up a condition step but I don't see how to do that in PA Desktop.

Thanks! 

Resolver I
Resolver I

No filters yet, so you have to use a For each loop to through the files. You can either perform whatever actions you want inside the loop if it is .xlsx, or add the corect files to another list to loop through afterwards.

@Henrik_M Thank you, I'm downloading them into a temp folder, copying only the xls, then removing the temp.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (68,113)