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? 🙂
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!