Unanswered

Automatically move Outlook e-mail attachment to SharePoint folder

(0) Share

Report

Posted on by JR-11081718-0

I want to automatically move an Outlook file attachment to a SharePoint folder once a day. My issue is that the file name (date portion) changes each day (ex. "....."_2024-08-10-07-05-10.xls; "....."_2024-08-10-07-05-11.xls; "....."_2024-08-10-07-05-12.xls; etc.). My "Power Automate Flow" keeps failing, I believe because of the date issue.

Looking for help and suggestions.

James

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Please post a screenshot of your flow

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

If you use the Retrieve email messages from Outlook action to retrieve the messages and save the attachments, you should have a list of emails stored in a variable in your flow. The variable by default is %RetrievedEmails%. You can then build a loop that processes those emails one by one. If, for example, you use a For each loop, each message will then be stored in %CurrentItem% for each iteration of your loop. Then, this %CurrentItem% variable will be of a special variable type called "Outlook mail message", which has a property called Attachments. So, using %CurrentItem.Attachments% you can access the list of files that were saved from this particular message. You can then use whatever actions you use to move them to SharePoint.

Was this reply helpful? Yes No