Flow throwing multiple emails when multiple choice options are selected on SharePoint List

[Jack23]

Hello Team,

I have a flow created to notify when a new item is added to SharePoint Online. The flow is working as intended but in the SharePoint list, I have a multiple choice box and when multiple options are selected and submitted, the flow is triggering multiple emails instead of one!. 

Is this the normal behavior or there's something missing in my flow which is triggering multiple emails ?

I checked for help on the forum referring to the previously added queries and found that this functionality of selecting multiple options is currently not available in Flow. Please confirm.

Please provide a workaround if available.

Best Regards

Jagadish

[v-xida-msft]

Hi @Jack23,

Could you please share a screenshot of your flow's configuration?

Do you create a Choice type column with the Checkboxes (allow multiple selections) option is enabled within your SharePoint list?

Further, could you please share a bit more about your Choice type column?

I suppose that you add a "Apply to each" action within your flow, is it true? Multiple Choice type values are not supported in Microsoft Flow currently. If you reference the Choice type values with multiple selections within actions under the trigger, the "Apply to each" action would be added automatically. My flow's configuration as below:

The Choice type values with multiple selections would be processed as a list of items within Microsoft Flow, we use "Apply to each" action to process the list of items. More details about the usage of "Apply to each" action, please check the following article:

https://docs.microsoft.com/en-us/flow/apply-to-each

Best regards,

Kris

[Jack23]

Hi Kris,

Below is what I have created.

On SharePoint List, I have a multiple choice type column called " Issues " and when I select multiple options in the " issues " and then submit the item, it throws multiple emails. I just want one email to come through which has information of all the selected issues.

SharePoint Choice Column is enabled. Below is the screenshot.

When I select both Wrong ticketing routing and wrong ticket priority, I want only one email to be sent as both entries are added to one item.

Please help.

Thanks

Jagadish

[v-xida-msft · Accepted solution]

Hi @Jack23,

Do you want to include Choice value with multiple selections into one email?

I have made a test on my side and please take a try with the following workaround:

• Add a "When a new item is created" trigger.
• Add a "Create HTML table" action, From set to Task Type dynamic content of the trigger, Include headers set to Yes and Columns set to custom. Within Custom columns map entry, insert one entry, Headers set to TaskTypeValue and corresponding value set to Task Type Value dynamic content.
• Add a "Send an email" action, Body field set to output of "Create HTML table" action.

Image reference:

Note: The Task Type column is a custom Choice type column with multiple selections, the screenshot as below:

The flow works successfully as below:

Best regards,

Kris

[Jack23]

Kris,

Perfect 

The fix you provided is working perfectly.

There's a problem in my output I guess. There's an extra tab after "Defect(s)". I tried using paragraph start & stop and also 

<p align="left"> but nothing is working here.

 

Below is what I have in my flow.

Please help me fix this.

Thanks

Jagadish

[mlzag]

I was having the same issue and this is still a perfect workaround, thanks!

[KarlC]

Hi.

My senario is very similar to the above but involves conditons with ORs logic which looks at multiple choice values selected from a sharepoint list, and then undertakes an action. The Apply to all kept getting added automatically by flow and I found dumplicate emails and entries were created.

Any thoughts on my senario for a work around would be most welcome:

A person creates an "Idea / suggestion" in a SharePoint list, and multiple choice column tick boxes for which technologies are impacted (for example the suggstion impacts accross multiple technologies so we need to alert the teams impacted). However if 1 team manages multiple technoligies - they get duplicate emails and planner tasks for each technology multiple choice tick box selected - and not just a single one for the new suggestion .

Flow will triger on a new item created, and using a condition if contains "SharePoint" OR "Teams" OR "Information Protection", then send an email alert and create a planner task for teamworking group. 

If No then another conditon if contains "Intune" OR "Information Protection" then email alert and create planner task for EMS team etc.

Idea is to send an alert and create a planner task for the teams impacted to triage the idea etc.

However it looks like with the apply to all being added, Flow will double up on the emails and planner tasks for the group. For example the teamworking team would then get multiple email and planner tasks for each multiple choice tick box selected (for example "SharePoint" OR "Teams" OR "Onedrive" will send 3 emails and create 3 planner tasks - and not just 1 for the new item).

Any thoughts most welcome (or is there any plans for support of multiple choice in Flow in the future?