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

636
2
Jump to solution
08-23-2023 05:53 PM
ScottPool
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
Jim-Moore
Esri Regular Contributor

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

View solution in original post

2 Replies
Jim-Moore
Esri Regular Contributor

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
New Contributor II

That works! Thank you!

0 Kudos