Separate multi-choice questions with semi-colon instead of a comma

[ScottPool]

Hi there,

I'm wanting to separate the answers to multi-choice questions with semi-colons instead of commas.

This multi-choice question allows users to select from a list of emails who they would like to send an automated email to when the response is submitted using Power Automate. The problem is, Power Automate does not allow emails to be separated by commas but only by semi-colons before it can send the email. If there's even a comma at all in the "To" field, it will refuse to send it.

So, it seems the best solution is to somehow replace the comma separators with semi-colon separators in this multi-choice question.

Thanks.

[Jim-Moore · Accepted solution]

Hi Scott

You could try to reconstruct the list in the survey itself, but it's probably easier to just replace the commas in Power Automate as you suggest.

For the "To" field in the email action, use the replace() function to replace the commas with semicolons. You'll find this in the Expression pane. The first argument for the function would be the comma-separated result from your select_multiple question. This would look something like:

replace(<insert select_multiple email question from dynamic content>, ',', ';')

Hope this helps! Jim

[ScottPool]

That works! Thank you!