I am trying to remove the text within the parenthesis as well as the parenthesis. The input is from Sharepoint "create item". In another flow, I was able to split the text, and use just what's in the parenethsis for a key column match, but now I'd like to do the opposite and be left with everything but what's in the parenthesis for my output.
Original String: Tiny Tots ELC - All Agency (CLS01803;CLS01925;CLS01807;CLS01903;CLS01928;CLS01927;CLS01842;CLS01844;CLS01902;CLS01924;CLS01859;CLS01926)
Desired String: Tiny Tots ELC - All Agency
triggerBody()['text'] is my output from manual trigger flow --> trim(first(split(triggerBody()['text'],'('))). just replace it output in expression - trim(first(split(outputs('Create_item')?['body/Classroom'],'(')))
If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.
Regards
Kaif
Sorry, I'm not sure how to do that....where would I put this: outputs('Create_item')?['body/Classroom']?
I've tried inputting this in the expression you provided and it is not working. Thanks for your help!
Use split to extract the desired string. ---> trim(first(split(triggerBody()['text'],'(')))
If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.
Regards
Kaif
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1