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 / How to get the value b...
Power Automate
Answered

How to get the value between any char

(0) ShareShare
ReportReport
Posted on by 90

Hi Team ,

         How to get the letters between any char

         Example i have [KME] ; [WER] ; [TE]

 

         Expected is KME , WER , TE

 

Thanks

Categories:
I have the same question (0)
  • Verified answer
    grantjenkins Profile Picture
    11,063 Moderator on at

    Hopefully this is what you're after.

     

    See full flow below. I'll go into each of the actions.

    grantjenkins_0-1671334712424.png

     

    Data contains your data.

    grantjenkins_1-1671334764353.png

     

    Compose extracts the data out using the following expression. Effectively, it removes the brackets, then splits by semi-colon. If you knew that your brackets were always separated by a space, then semi-colon, then space, you could have just split on " ; " instead of just ";" which would remove the spaces, but assuming this might not always be the case so just splitting on the semi-colon.

    split(replace(replace(outputs('Data'), '[', ''), ']', ''), ';')

    grantjenkins_2-1671334915981.png

     

    Select is trimming your values (removing any unnecessary spaces at the start and end of your text. The expression used is:

    trim(item())

    grantjenkins_3-1671334984579.png

     

    This would give you the following output.

    grantjenkins_4-1671335018938.png

     

    Join will then join each of the values in the array. In this example I've joined them by ", ".

    grantjenkins_5-1671335093023.png

     

    This will give you the output below.

    grantjenkins_6-1671335107662.png

     

  • Ayappan Profile Picture
    90 on at

    Thank you very much @@grantjenkins 

     

    I have to add one more condition . now data is updated with some more text 

    Eg :  [KME] - Test1 

            [WER] - Test2

           [TE]  -  Test3

            [KME] - Test4

     

    Now also i need only KME , WER , TE. Is this using same above @grantjenkins 

    Thanks ..

     

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard