Announcements
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.
Hi @DML1 ,
Not sure how the compose action is obtaining the input value but you could use some of the string functions in the expression to remove the parenthesis and other unnecessary characters.
Please check:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#string-functions
Thanks and Regards,
Vikas K
Thanks Vikas for the response. Attached are the part of flow... Ignore the html table part in the last image.
Subject is one of the column from excel table. Union function used for unique email id.
From filter array used select action to pick up subject column...item()['Subject'] and then compose.
Added the output of compose action in the subject line of the email.
Hi @DML1 :
I've made a test for your reference:
The Result:
Best Regards,
Bof
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
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?
Pls find the input and output of select and compose action
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
I've made a test but there is no '[' or ']' besides the 'Open':
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?
Please try:
replace(replace('[""OPEN','[',''),'"','')
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
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 552
Valantis 388
11manish 375
