Here is a slightly different version for saving a Microsoft Forms multi-select choice field to a SharePoint multi-select choice column.
(1) Here is the multi-select choice column as defined in SharePoint:
(2) Here is the Microsoft Form showing the multi-select choice field for a selection of fruit. The choice values match exactly the choice values in the SharePoint column:
(3) Add a Select action, and for the From property enter the expression as shown below. For the expression, you need to wrap the MS Forms choice question inside a json function:
Here is a closer look at the expression for the Select From property:
(5) In the Select action, add a property key called "Value", and for the value, enter the expression item() as shown below:
(6) In a SharePoint Create item action, use the output of the Select action for the value of the SharePoint choice column:
(7) Here we see how the MS Forms selection is saved to SharePoint:
Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!
