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

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! 

Henrik_M
Super User
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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