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
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
I applied the extension excel format .xlsx and it works perfectly!!
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional