Power Platform Community Forum Thread Details

I humbly need help creating a flow that saves attachments from Outlok 365, to a specific sharepoint folder path/subpath, or creates it, based on the subject.

For example, I am part of an email group where if someone sends something to retention@outlook.com and it has an attachment, it will look at the email subject "Airplane 770 Flight 120" and save it to the folder path "Sharepoint\Airplane 770\Flight 120". And then if I get one that says "Airplane 770 Flight 121" it saves it to "Sharepoint\Airplane 770\Flight 121". It would also be awesome if the email subject said "Airplane 770 Flight 120 MaintenanceReport" and saved the attachment to "Sharepoint\Airplane 770\Flight 120" and called the file "Airplane770_120_MaintenanceReport". How can I have it read that email subject and split to a folder/subfolder like that?

There would also be a dozen different possible file names per airplane per flight, so one could be MaintenanceReport, EngineReport, Wingreport, fuelreport, expensereport, etc. Is it possible to have it separate Airplane 770, Flight 120, and just look for any word or phrase that comes after, save it as, for example "Airplane770_120_Rest_of_the_email_subject?" or should it be a long chain of switch statements where it chooses between "Maintenance, Engine, Wing, Fuel, expense" etc to append to the end of the file name?

I'm a little familiar with first semester fundamental programming in python, C++, C#, but I'm not at all familiar with Power Automate, and the way that it can do things. I'm not sure what is possible and what isn't possible, and how I would implement it.

This is for work and I have a sort of deadline, and I just have so many other things to do each day that I never get to spend any time really learning Power Automate or testing things out like this.

If you have tips on how to solve this fast, and any good supplemental videos and articles to check out, anything helps. Thank you!

Quick Links