Change Filename to Title Case Desktop in middle of a Flow

(1) Share

Report

Posted on by SanjayGMusafir

Hi Experts

This in continuation to the thread -

https://community.powerplatform.com/forums/thread/details/?threadid=0a3ff920-05b9-ef11-b8e8-7c1e521c6682

where @eetuRobo provided me with the required answer

Now a new situation came up.

I tried to use his method -

When I do exactly as advised, it works fine.
But at times I need to use it in the middle of a flow (screenshot attached). At that time it gives error - Unable to rename file.

Please help

Thanks a lot 🙏

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Hello!

Problem is that Rename files -action creates a list of files.

And when your second Rename file(s) -action tries to rename the file it gets a list value when it should get string of the file path. So you need to refer to the %R000% -variable as %R000[0]% to get the first list item (in your case there will always be just one list item since it takes just one per loop).

Also since your Current item is File-type variable with different properties you want to use "NameWithoutExtension" or in the second Rename file(s) action toggle off "Keep exension" (otherwise it will rename the file "Test Name.Txt.txt")

Try like so:

Hope this helps!

Was this reply helpful? Yes No
SanjayGMusafir 73 on at

Like (0)

Report

@eetuRobo Thanks for helping.

My challenge is that I'm unable to understand how to add properties to these. If I type manually, it gives error.

Please advise.

Thanks a lot 🙏

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report
Happy to help!

Like so:
%R000[0].NameWithoutExtension%

Since the R000 is a list you need to tell it which item you are referring to. So in your case the R000 list will always have just one item so you reference the first item which is index zero %R000[0]%. Then add dot and the property "NameWithoutExtension".

Sometimes PAD also knows to give them to you in the variable selection when you expand the CurrentItem

You could also do the flow like this. I tried to explain in red text what the actions do:

Copy the actions to your flow:
Display.SelectFileDialog.SelectFiles Title: $'''Choose Files''' InitialDirectory: $'''C:\\Users\\x''' IsTopMost: False CheckIfFileExists: False SelectedFiles=> SelectedFiles ButtonPressed=> OpenFiles File.RenameFiles.RenameReplaceText Files: SelectedFiles TextToReplace: $'''_''' ReplaceWith: $'''%' '%''' IfFileExists: File.IfExists.DoNothing RenamedFiles=> R000 SET oNames TO R000 IF OpenFiles = $'''Open''' THEN LOOP FOREACH CurrentItem IN oNames Text.ChangeCase Text: CurrentItem.NameWithoutExtension NewCase: Text.CaseOption.TitleCase Result=> nName File.RenameFiles.Rename Files: CurrentItem.FullName NewName: nName KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> R002 END END

Was this reply helpful? Yes No
SanjayGMusafir 73 on at

Like (0)

Report

@eetuRobo Thanks a lot 🙏

That did the magic

Was this reply helpful? Yes No