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 advance
Solved! Go to Solution.
I applied the extension excel format .xlsx and it works perfectly!!
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
Proud to be a Flownaut!
I applied the extension excel format .xlsx and it works perfectly!!
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
Proud to be a Flownaut!
User | Count |
---|---|
6 | |
6 | |
6 | |
4 | |
2 |