Forum Discussion

Copper Contributor

Dec 28, 2017

Flow doesn't process multiple value in custom list

I created a basic Flow to generate an email when a new item is created on a Custom list. The flow works without problems until I add a Multiple Choice or Lookup to a multiple choice field. Th...

Iron Contributor

Dec 28, 2017

Davide Picone

Please read over this thread. I spent about 2 weeks working on this and ultimately Flow Support forums could not fix the issue and said multiple choice value fields are unsupported at this time in flow.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-list-submission-notification-flow-cant-add-fields/td-p/72861

I did not want to accept this as an answer as this had worked for me for multiple months up to the change about a month and a half ago.

I have an open support ticket with Microsoft through our Enterprise Agreement now to investigate. They agree that functionality should not have been removed in an update and are currently investigating. It has been about a week since I heard back from my case worker.

Robert Woods
Iron Contributor
Jan 13, 2018
Hi Robert,

Product team investigated regarding the issue and confirmed that due Choice column with multiple values allowed is an array, and hence flow is converting the action into “Apply to each” loop. Please verify if your column, and verify if it is same as shown in attached screen shot.

As a workaround, product team is suggesting to use “Compose” action instead and use “concat” function to avoid looping. While sending email use the

Please find the below link regarding concat and “Join” operation.

https://docs.microsoft.com/en-us/flow/data-operations

Regards,

Narender Reddy Satty

Engineer - Microsoft Business Intelligence