Renaming file where source file name varies

(0) Share

Report

Posted on by smacsween

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?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Filename:

first(split('FILENAMEPROPERTIE','.'))

Fileextension:

last(split('FILENAMEPROPERTIE','.'))

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

Was this reply helpful? Yes No
smacsween 2 on at

Like (0)

Report

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
1024535.xlsx
57232234.xlsx
and each time I run the flow, i want it to select the relevant filename and change it to "profiles.xlsx"

Any ideas? 🙂

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@smacsween ohh to find files you can use this actions to one drive or sharepoint

Was this reply helpful? Yes No