3

Desired Behaviour

Add Microsoft Form responses to a SharePoint list using this flow:

Record form responses in SharePoint

Current Behaviour

It is working, however the value of a Multiple Answer, Choice field is being added to the SharePoint list like this:

["Option 1", "Option 2", "Option 3"]

rather than this:

Options 1, Option 2, Option 3

What I've Tried

The column in the SharePoint list is of type:

Choice  
Allow multiple selections

Therefore, I made the corresponding field in the Microsoft Form of type:

Choice  
Multiple Answers  

I can change the value received from the form like this (learned from this post):

enter image description here

and the value will appear in the SharePoint list as either:

Option 1, Option 2, Option 3

or:

Option 1; Option 2, Option 3

However, when trying both of these delimiters (with and without spaces after them ¯\_(ツ)_/¯), when I Right Click > Edit on the item in the SharePoint list, the options are not selected in the Edit panel on the side of the page.

Question

What format is required when adding values to a Choice > Allow multiple selections column in a SharePoint list?

3

Make the join value this (a semicolon and a hash - ;#):

enter image description here

Gleaned from this answer:

https://sharepoint.stackexchange.com/a/78912

2
  • TO DO: see if a similar solution is required for adding a date value, or if dd/mm/yyyy format will suffice. Apr 13 '20 at 5:31
  • Update: Indeed it seems some trickery will be required as sending dd/mm/yyyy does not add a value to the SharePoint list that forces the calendar widget on the date field to be ‘prepopulated’ with the relevant date when editing the item. Apr 15 '20 at 16:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.