You’re offline. This is a read only version of the page.
Announcements
Hello, everyone.
Now I'm trying to create flow for saving email attachments from sharemail.
It's not difficult to save all files in same folder, but is that possible to save files in different folders based on content of email?
For example, I have 40 clients who send me reports monthly. And I'm need to save this files in correspond folder on OneDrive (Year-Name-Month).
I've been thinking about creation of dynamic path with variables (array) which determine folder path based on part of email after @. (Example, forwarded email content @Test21.com and it's should be saved in Onedrive/reports/2021/test21/2021-03)
I have Excel file (vocabulary) with 2 columns ClientName which differ Folder and DomainName that should be found in email.
What is the best way to do it, if it's possible?
@Afan if you have excel file that has list of clientname, domain name to check in from email and folder path, then first get rows from excel using List rows present in a table.
Then add Filter Array action and in From parameter select value (list of items) of List rows action, and configure other parameters as shown in below screenshot, select from email from Email trigger on left value and on right value select the column from excel which has domain value.
So now Filter Array output will give you row from excel which matches with the domain in from email, so further you can get value of folder path from filter array output to get the folder path to which the files are to be copied.
Share
Report
All responses (
Answers (
8,531
