converting certain words in file name to upper case for all files in document libary

Question

I am looking for a powershell or may be flow approach to convert certain words used in Sharepoint file name to upper case. For example,a document library contains about 200 files. Each of these files may or may not contain words like Ln, Plc, Az etc.

The goal is to see if these words are present in the file name first and if so then convert them to upper case. So that way it can be converted into LN, PLC and AZ. This is something I want to perform on all existing files that reside in sharepoint online doc library. So looking for either powershell or flow approach to make it to work, or any other way if possible to do so.

This is a different question, its not a duplicate question. The requirement is different in this case, please read my question description. The question I had asked here was for the whole file name: upper/lower case naming convention for Document name in SPO Doc Lib. I am using this solution currently. But now i need another script or flow to catch certain words in the file name across the document library and only make them turn into upper case. thanks in advance.

Answer 1

use this flow i created few days ago, but in one thing, change to function:

CHANGES:

after some chat here is solution with dictionary for upper case words:

1. Create Custom List in SPO, only with Title. Fill Title with words you want to keep uppercase:

1. Initialize another variable UpperCaseCol at the start of the Flow which I referred here:
2. Get items from this List with SharePoint Get Items function:
3. Create Apply to Each before the existing one
   • Output from previous step: Get items - value
   • Set Variable: Working with Get items - Title
   • Append to string - Name: UpperCaseCol, Value: concat(toUpper(variables('Working')),',')

1. Edit Apply to each - existing from the referred flow, edit the body
   • Insert Condition after setting variable Working, condition will be variable(UpperCaseCol) contains toUpper(variables('Working'))
   • YES: create new Append to string variable - Name: CorrectName, Value: concat(' ',toUpper(variables('Working')))
   • NO: moved existed Append action

Thats everything, Flow will looks like:

Document names changed:

from:

to (Ar was not in the UpperCase list, its OK):

CHANGES PATH TWO - FIXING LAST WORDS AND '-' before them:

1. Move Initialize variable - Working as first Initializing (you will need it) and fill value with: replace(triggerBody()?['{Name}'],'-',' - ') - this will create always '-' with a spaces from both sides (it's the easiest way)
2. Change Initialize variable NAME - value: split(variables('Working'),' ')
3. Thats everything, it will looks like:

BEFORE:

AFTER: