cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hamid
Resolver I
Resolver I

Saving email attachments with a fixed name in Onedrive folder

HI Guys, 

 

 Hope you all doing great. 

I built a flow to detach the excel attachments from specific emails and save it in Ondrive folder. The issue is each attachment comes with a different name every day, and I want to have them saved with a fixed name, doesn't matter the name so My excel query recognizes it. I tried typing a fixed name in the file name filed in the Create File module, but doing that makes the attachment saved with no format. Is there any way I can do this? 

 

Thank you in advanceflow 2.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Hamid
Resolver I
Resolver I

I applied the extension excel format .xlsx and it works perfectly!!

View solution in original post

efialttes
Super User
Super User

Hi!

"I tried typing a fixed name in the file name filed in the Create File module, but doing that makes the attachment saved with no format."

The problem is, you need to read the extension from original File Name and add it at the end of your 'default file name'

Good stuff here

https://www.timlinenterprises.com/microsoft-flow-substring/

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

2 REPLIES 2
Hamid
Resolver I
Resolver I

I applied the extension excel format .xlsx and it works perfectly!!

efialttes
Super User
Super User

Hi!

"I tried typing a fixed name in the file name filed in the Create File module, but doing that makes the attachment saved with no format."

The problem is, you need to read the extension from original File Name and add it at the end of your 'default file name'

Good stuff here

https://www.timlinenterprises.com/microsoft-flow-substring/

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,328)