cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SCO_PP
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
geavgous
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
geavgous
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

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! 

Henrik_M
Dual Super User
Dual Super User

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,560)