Need Help Removing Brackets, Parenthesis and Quotes Power Automate

(0) Share

Report

Posted on by LG-19101834-0

Hello Power Automate: I have a people picket column that keeps including brackets, parenthesis, and quotes. I added the following action to remove them, but they have not been removed:

replace(replace(outputs('Join'),'[',''),']','')

I want the inputs in brackets to just include the names

Categories:

Business Process Flows

All responses (2)

Answers (0)

Suggested answer

CU21101414-0 on at

Like (0)

Report
Need Help Removing Brackets, Parenthesis and Quotes Power Automate

There are multiple ways to handle this problem, but since I have ran into needing to do similar things to cleanup characters for folder names, fields, etc... You can create an array of characters you wish to remove and then loop through them.

Create a variable for your data (in my case this was a folder name):

Create your array of characters to remove:
Example:

createArray('.','@','ß','²','³','µ','´','°','^','=','(',')','&','$','§', '~','#','%','*',':','<','>','?','/','|',' ', '[', ']', '"')

Loop through your array of characters.

Use compose to replace the current character in your string.
Example:

replace(variables('varFolder'), item(), '')

Update your variable with the cleaned output.

Once done, you should have a value clean of any unwanted characters.
Suggested answer

David_MA 6,664 on at

Like (0)

Report
Need Help Removing Brackets, Parenthesis and Quotes Power Automate

Since you don't show how you configured the actions in your flow, I am not sure what you are doing. But, to get people out of a people picker field and have the names semicolon separated, you would do this:

Create an array variable with a default value of []

Add an Apply to each action to the flow and point it to the people field through the dynamic content picker, choosing the option that does not contain DisplayName after it:

Then add an Append to array action and enter the people picker field that does have DisplayName after it.

You can then use a join expression on the variable to combine then into one string separated by the value of your choice. For example: join(variables('Approver'), '; ')