Hi @Iantaylor2050,
You can follow one more here.
What you need is: Parse the Email Subject, to do so let's follow these steps:
1. Add a "Compose" action to get the email subject. In the Inputs field, select the dynamic content "Subject" from the email trigger.
2. To extract specific parts of the subject to make or create folder, for example "ABC11345 - White Board Logistics Pvt Ltd."
add another "Compose" action and use an expression. For example, to get "White Board Logistics Pvt Ltd" from a subject like
last(split(outputs('Compose_Subject'),' -')) //-- This will output "White Board Logistics Pvt Ltd" that is your first folder name
One more compose to take first(split(outputs('Compose_Subject'),' -')) //==this will output ABC11345, your last folder name.
NOTE: You may need to adjust the expression based on your exact subject line format and strip off the extra spaces if any.
3. Create the Folder --> Add a "Create new folder" action for your chosen storage (e.g., SharePoint, OneDrive). Select your Site Address or destination. In the Folder Path field, use the dynamic content output from your "Compose" action (which holds your parsed subject/folder name).
NOTE: Ensure the folder name does not contain invalid characters for your specific storage location.
Finally, when you create file, make sure already created folders are there or use the folder names that you have already extracted using compose and expressions. In the Folder Path, you will be using 3rd level folder name from the extracted Compose method.
Please le me know if this helps.
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
