Saving specific email attachment to OneDrive - save cvs files in different folders

[Anonymous]

Hi, 

I am new to power automate. I would like to save the CVS files in the email attachment to different folders in my OneDrive respectively with Power Automate. 

1. Receive emaill attachment

2. In the attachment, there is two CVS files - _all_items_all_cards_Date AND _all_orders_with_card_and_oracle_updates_Date

3. I would like to save the two CVS files to their folders respectively.  

Could you please advise me how to set up the flow:)

Many thanks

Kelvin

[DamoBird365 · Accepted solution]

Hi @Anonymous 

I would start with the following trigger setup to filter on subject and only if there is an attachment:

You then want to get the attachment, create the zip file on One Drive and Extract the zip to a "temp" folder.  If you are new to Power Automate, it will insert the apply to each for you but you can avoid it if you know you have a single attachment.  An improvement for another day.

You then want to list the files in the temp folder and using a compose, create the new path by replacing /temp/ with either /_all_items_all_cards/ if the file name contains all_items_all_cards OR your other path /_all_orders_with_card_and_oracle_updates/

i.e.

if(

contains(items('Apply_to_each_2')?['Path'],'all_items_all_cards'),

replace(items('Apply_to_each_2')?['Path'],'/temp/','/_all_items_all_cards/'),

replace(items('Apply_to_each_2')?['Path'],'/temp/','/_all_orders_with_card_and_oracle_updates/')

)

You can then move the file using the path from list files in folder and the output of the compose i.e. the new path.

The only other tidy up might be to delete the original zip file.  That can be done with the delete file action.

I ran this on an incoming email with the following result:

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[Anonymous]

Hi @DamoBird365 

For some reason it was fail at "move or rename a file using path" Please refer below,

Do you know what i have done wrong?

Many thanks

Kelvin

[DamoBird365]

Hi @Anonymous 

I believe you have used the path for the zip, rather than the path from the list files i.e. the CSV.  You can see that in the screenshot file path.

Damien

[Anonymous]

Hi @DamoBird365 

I have selected the path from the list files in folders. But it still shows an error..

Cheers

kelvin

[DamoBird365]

Hi @Anonymous 

Can you share with me the error and what you see in the history. Are you rerunning the original history or triggering with a new file? 

Damien

[Anonymous]

HI @DamoBird365 

I triggered a new file and error is still appeared. Please refer below, 

Show 1 of 2

File Path shows : 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_items_all_cards_2022_Jan_09_06_30.csv

Destination File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_items_all_cards_2022_Jan_09_06_30.csv

Show 2 of 2

File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_orders_with_card_and_oracle_updates_2022_Jan_09_06_30.csv

Destination File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_orders_with_card_and_oracle_updates_2022_Jan_09_06_30.csv

Many thanks

Kelvin

[Anonymous]

HI @DamoBird365 

I triggered a new file and error is still appeared. Please refer below, 

Show 1 of 2

File Path shows : 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_items_all_cards_2022_Jan_09_06_30.csv

Destination File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_items_all_cards_2022_Jan_09_06_30.csv

Show 2 of 2

File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_orders_with_card_and_oracle_updates_2022_Jan_09_06_30.csv

Destination File Path Shows: 

/drives/b!32Q52GoMB02Eg6h6l1Lric-J96HX_KJIvc6aewZ0ZuAc3N4qFzruQbyuabcr0rOI/root:/IMS PowerBI Dataset/Temp/all_orders_with_card_and_oracle_updates_2022_Jan_09_06_30.csv

Many thanks

Kelvin

[DamoBird365]

Hi @Anonymous 

Your source and destination are the same. Please check the compose and your expression. It’s not working.

Damien

[Anonymous]

HI @DamoBird365 

Below is the expression i've put with compose. Could you please advise if i need to review it?

Cheers

kelvin

[DamoBird365]

Hi @Anonymous 

It will be a capital T in temp as replace is case sensitive. Either rename folder to temp rather than Temp or update replace where all instances of temp equal Temp.

Damien

[Anonymous · Accepted solution]

Hi @DamoBird365 ,

Perfect! It is sorted. Many thanks!

Cheers

Kelvin