Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Remove brackets, paranthesis and quotes

(0) ShareShare
ReportReport
Posted on by 136

How to remove brackets, paranthesis and quotes from compose action. Attached image for refference(Red highlighted - subject of a email). I need only text.

 

And leads on this please.

IMG_20220101_112718~3.jpg

  • Verified answer
    DML1 Profile Picture
    136 on at
    Re: Remove brackets, paranthesis and quotes

    Hi Bof,

    Thanks for the constant effort to solve my issue.

     

    I solved the issue with other workaround, pls find my other post in the below link,

     

    https://powerusers.microsoft.com/t5/Using-Flows/Create-email-subject-line-from-array/m-p/1404984#M27922

     

    Regards,

    DML

  • v-bofeng-msft Profile Picture
    on at
    Re: Remove brackets, paranthesis and quotes

    Hi @DML1 :

    vbofengmsft_0-1641290018891.png

    Best Regards,

    Bof

     

  • DML1 Profile Picture
    136 on at
    Re: Remove brackets, paranthesis and quotes

    Sorry Bof if I am asking a silly question. I am not clear how can I use the Replace function because how to insert a replace expression within output of select or compose.

     

    In your flow you directly used a text in compose, mine is not the same case as mentioned in my previous reply 

  • v-bofeng-msft Profile Picture
    on at
    Re: Remove brackets, paranthesis and quotes

    Hi @DML1 :

    Please try:

    replace(replace('[""OPEN','[',''),'"','')

    Best Regards,

    Bof

  • DML1 Profile Picture
    136 on at
    Re: Remove brackets, paranthesis and quotes

    Is it because I used concat formula(combing multiple columns) in excel table under Subject column to get unique subject?

     

    But concate formula doesn't have [ ] and ".

     

    If my assumption is correct then pls help me to to resolve this Bof?

  • v-bofeng-msft Profile Picture
    on at
    Re: Remove brackets, paranthesis and quotes

    Hi @DML1 ,

    I've made a test but there is no '[' or ']' besides the 'Open':

    vbofengmsft_0-1641277615907.png

    The Result:

    vbofengmsft_1-1641277632170.png

    Best Regards,

    Bof

     

     

     

  • DML1 Profile Picture
    136 on at
    Re: Remove brackets, paranthesis and quotes

    Pls find the input and output of select and compose action

    IMG_20220104_113909.jpg

    IMG_20220104_113925.jpg

    In the 2nd image you can see the output has array/object symbols [ ] same thing along with " reflecting in subject line of the email.

    Regards,

    DML

  • v-bofeng-msft Profile Picture
    on at
    Re: Remove brackets, paranthesis and quotes

    Hi @DML1 :

    After reading the connection you provided, I realized that the output of compose you mentioned is an array.

    Could you show me the complete out put of this action?

    vbofengmsft_0-1641273215303.png

    Best Regards,

    Bof

     

  • DML1 Profile Picture
    136 on at
    Re: Remove brackets, paranthesis and quotes

    Thank you so much for the effort Bof. I am not able to see the replace expression clearly when I zoom the text. Please share the replace expression as text.

     

    I got the workaround to remove the array characters from subject line but still [" "] exist. 

     

    Pls refer the below link

     

    https://powerusers.microsoft.com/t5/Using-Flows/Create-email-subject-line-from-array/m-p/1403019

  • v-bofeng-msft Profile Picture
    on at
    Re: Remove brackets, paranthesis and quotes

    Hi @DML1 :

    I've made a test for your reference:

    vbofengmsft_0-1641262642129.png

    The Result:

    vbofengmsft_1-1641262657218.png

    Best Regards,

    Bof

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow