I am trying to build a flow to rename a source file, xlsx format.
But the filename of the source file varies each time it is created by a third party.
It is the only xlsx file in that OneDrive folder.
PA seems to require me to choose a particular file but the filename differs each day.
What do I need to add to my flow to pick up that xlsx file, irrespective of whatever it is called on that day, and rename it to the non-changing filename?
hi @smacsween what you can do is use expressions.
Imagine that you have this name in a propertie call FileName: myfilexample.xlsx
so you can add a compose action and inside an expression to get the filename of the file extension
If you want to see who you can add expression you can see my video here https://www.youtube.com/watch?v=MHvWuFMXhes
I hope this can helps
Thanks Christian. Your solution is good but it only works where I know the filename already.
I want the flow to search for the xlsx file - note it will be the only one of that filetype in the folder, then depending on that filename, change the filename to a new, standard filename.
For example the filenames may be
and each time I run the flow, i want it to select the relevant filename and change it to "profiles.xlsx"
Any ideas? 🙂