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 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,
Regards,
DML
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
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?
Hi @DML1 ,
I've made a test but there is no '[' or ']' besides the 'Open':
The Result:
Best Regards,
Bof
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
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?
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
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional