Power automate SharePoint multiple choice column to string

In this Power Automate or Microsoft Flow tutorial, we will see how to convert SharePoint multiple choice column to string using Power Automate.

While working for a client, I came across a requirement, when a user will create an item in the SharePoint list, if the user will select multiple options in the choice column and the receiver will get an email automatically with all the selected options in a string with comma separated between each value.

For example, there is a list called ‘Online Traveller Details‘. In this list let’s say, the columns are i.e Name (Single line Text), MovingTo (Choice column: choices for the certain region), MovingFrom (Choice column), and Date (Date and Time).

power automate sharepoint multiple choice column to string
Power Automate send emaill with multiple selected options

So when a new item is created in the list and the user selects multiple options from the MovingTo field, the receiver will get an email with multiple options automatically using Power Automate or Microsoft Flow. Here is how our flow looks:

power automate get value of choice field sharepoint
send email with multiple selected options using Power Automate

Power automate SharePoint multiple choice column to string

Now let’s see how we can create this flow using Power Automate step by step.

Step 1: In Power Automate, click on the +Create option from the navigation -> select Automated Cloud Flow.

power automate get value of multi choice field
send email with multiple selected options value using Power Automate

Step 2: Then Build an Automated Cloud Flow window will open, here provide the Flow name, and select the trigger ‘When an item is created‘(SharePoint) from the list of triggers. Click on Create.

power automate get value of multi choice field
send an email with multiple selected options values using Microsoft flow

Step 3: Then provide the Sharepoint site under the Site address and the list name under the List name in the ‘When an item is created’ trigger. It will start the flow when a user will create an item in the SharePoint list.

send an email with multiple selected options value using microsoft flow
send an email with multiple selected options value using Microsoft flow

Step 4: Now we will initialize an array variable, later we will use this variable to append the value. So, click on ‘+New Step‘ option, select Initialize variable option, and then provide the name of the variable, and select the Type as ‘Array‘.

power automate multiple choice to string
send an email with multiple selected options value automatically with flow

Step 5: Then click on ‘+ New Step’, and choose an action as ‘Append to array variable‘. Provide the Name from the dropdown, and Select ‘MovingTo Value’ from the dynamic content. Then it will automatically add the Apply to each action.

power automate multiple choice to string
send an email with multiple selected values automatically with the flow

Step 6: Next outside the ‘Apply to each‘ action, click on the ‘+New Step‘. Select the ‘Compose‘ action. Provide the input from the dynamic content, and select ‘Multiple regions’ under Variable.

power automate get value of choice field sharepoint
how to send an email with multiple selected value automatically with flow

Step 7: Click on ‘+New step’, then select Join action under Data operation,-> in the From field, select ‘Outputs‘ under Compose in Dynamic content, and in Join with Field provide the delimiter like comma ‘,’. Join operation will convert the above array values into a string with comma separated.

power automate sharepoint multiple choice column to string
how to send an email with multiple selected value using microsoft flow

Step 8: Now to send an email, click on the +New step, and select the ‘Send an email(V2)’ action. Then provide the receiver email in the To field, the Subject of an email, and in the Body provides the like below information from the dynamic content.

power automate get value of choice field sharepoint
how to send an email with multiple selected value using Power Automate

Step 9: Save the Flow, click on Test -> select Manually trigger flow -> then click on the Test button.

power automate multiple choice to string
Using Power Automate how to send an email with multiple selected value

Now create an item in the SharePoint list to trigger the Flow like below.

multiple choice to string using power automate
Using MS Flow how to send an email with multiple selected value

Now navigate to Power Automate in the browser, and you can see your flow ran successfully.

power automate get value of choice field Sharepoint
Using Microsoft power automate how to send an email with multiple selected value

As the Flow was run successfully, an email appeared in Office 365 Outlook. I n which several locations values from the SharePoint MovingTo column are picked and are presented in a string with commas between them.

power automate sharepoint multiple choice column to string
power automate SharePoint multiple choice column to string

This is how to send an email with SharePoint multiple choice column value in a string format using Power Automate.

See also  How to Create an HTML Table in Power Automate?

Conclusion

In this Power Automate tutorial, we saw how to convert SharePoint multiple-choice columns to strings using Power Automate.

You may also like:

>