web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split string by upperc...
Power Automate
Answered

Split string by uppercase followed by lowercase

(0) ShareShare
ReportReport
Posted on by 23

Hello community!

 

I need to split a string (file name) by uppercase followed by lowercase (or lowercase followed by uppercase)

Reason: I have a file name where all words and acronyms are written as one string. I have to split it, but acronyms have to be ignored.

Example: ImportantInformationFromCEOMaxMusterman 

Desired output: Important Information From CEO Max Musterman 

I managed it to split it by every capital letter, but it is not that what we really need. 

 

I understand, that the logic has to be like here: python example  or here 

but I struggle with translating it into "PowerAutomate".

 

 

Categories:
I have the same question (0)
  • DJ_Jamba Profile Picture
    2,837 Moderator on at

    Hi @JLS_ 

    Does this solution help you?

  • Verified answer
    Chriddle Profile Picture
    8,515 Super User 2026 Season 1 on at

    Chriddle_0-1716910925062.png

     

    Select

    From

     

    range(0, length(outputs('Compose')))

     

    Map

     

    if(
    	greater(item(), 0),
    	if(
    		and(
    			contains('ABCDEFGHIJKLMNOPQRSTUVWXYZ', chunk(outputs('Compose'), 1)[item()]),
    			or(
    				not(contains('ABCDEFGHIJKLMNOPQRSTUVWXYZ', chunk(outputs('Compose'), 1)[sub(item(), 1)])),
    				contains('abcdefghijklmnopqrstuvwxyz', chunk(outputs('Compose'), 1)?[add(item(), 1)])
    			)
    		),
    		concat(' ', chunk(outputs('Compose'), 1)[item()]),
    		chunk(outputs('Compose'), 1)[item()]
    	),
    	chunk(outputs('Compose'), 1)[item()]
    )

     

     

    Compose 2

     

    join(body('Select'), '')

     

    Chriddle_1-1716911019175.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 239 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard