How to save an email attachement (excel file) in a sharepoint folder after having deleted all existing files in this folder ?
I have just discovered the potential of Power Automate, but I have never used it before. So I'm really a beginner and I'm not sure to understand yet all the logical applied in this tool.
I would like to save in a sharepoint folder an excel file that I receive everyday attached to an email (always from the same list of people). I need to have just one file in this folder, which is the last received. The name of the file changes everyday because it contents the date of the day. So it means, that I want to delete all others files in this folder.
1. Trigger - When an email arrives (ensure that you flag the include attachments and has attachments to yes and add a subjec filter so that it picks up those emails only)
2. List folder from SharePoint (select the folder created for the files)
3. Apply to each item returned from previous step and add action to delete the files.
4. Add action to create file in sharepoint and provide the necessary parameters. (note that this will result in an apply to each loop again but as long as there are no images or other attachments in the email, it should be fine)
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!