4

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?

Improve this question
1
  • TO DO: Same question for updating multiple options Lookup column - comment from OP :/.
    – user1063287
    Commented Jul 27, 2022 at 4:11

1 Answer 1

Reset to default
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

Improve this answer
2
  • TO DO: see if a similar solution is required for adding a date value, or if dd/mm/yyyy format will suffice.
    – user1063287
    Commented Apr 13, 2020 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.
    – user1063287
    Commented Apr 15, 2020 at 16:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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