Hello there,
I am new to power automate desktop. I am trying to rename a bunch of files but having issues asking Power Automate to name it in the format I require.
I need to rename files as LASTNAME, Firstname. I have managed to create a flow that can extract the file name and convert to the format I need but the problem happens during the renaming of the file. I have realized that power automate cannot rename the file when there is a comma followed by a space (ie: "xxx, xxx"). And there is no error when I run the flow. The flow completes but the file will not be renamed.
I have tried running a one-line flow just for renaming and when I specify a name with comma followed by space, power automate will just not rename the file but complete the flow. Other format works for renaming such as comma alone, space alone, underscore and space.
Have anyone else encountered this issue? Is there any explanation to it or am I doing something wrong. Please advice and thank you all.
