web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Translating a choice f...
Power Automate
Unanswered

Translating a choice from a Form to a Choice in SharePoint list

(0) ShareShare
ReportReport
Posted on by 34

I have a Microsoft Form which has a multiple choice question (multiple answers allowed), in this example:

Morning

Afternoon

Evening

 

In my SharePoint List, I have a column which is formatted as a choice with the exact same choices. In both the Form and the List multiple-answers is allowed.

 

I have a Flow which is grabbing the Form fill data and creating an item in the SharePoint list. The problem is the way it gets displayed in the list. If someone checks off both Morning and Afternoon in the form for example, what appears in the list is:

["Morning","Afternoon"]

 

I tried formatting the column as text instead of choice, but I get the same result.

 

If I manually enter an item in the list and check off those two what appears is:

Morning, Afternoon

 

Is there anyway to work the Flow so that the result is clean like that?

 

Thanks in advance.

Categories:
  • efialttes Profile Picture
    14,756 on at

    Hi!

    Great article here explaining the exact same scenario you have:

    https://365basics.com/microsoft-flow-populate-a-multi-choice-field-in-sharepoint/

    Please read it carefully, since it starts explaining how SP multichoice works from Flow perspective, then introduces how Forms multichoice works from Flow perspective

    Hope this helps

  • BFlow Profile Picture
    34 on at

    Thank you for that. I'm having a super hard time getting it to work though, probably because I dont fully understand the mechanics of it.

     

    It think I have it right, but its giving me an error:

     

    ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_response_details')?['body/re275778528fd421da8e51ae202340ef2']' is of type 'String'. The result must be a valid array.

     

    Here is what I have:

     

    Capture.JPG

     

    When on Monday is the question on the Form which is multiple choice (morning, afternoon, evening).

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @BFlow 

     

    Please put your expression in Dynamic expression text like this-(my expression is random one, not related to your problem)

    Hardesh15_0-1600453299065.png

     

    Thanks

    Hardesh

     

  • BFlow Profile Picture
    34 on at

    Thank you. I've made that change, but get the same error.

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @BFlow 

     

    Please share your flow running screen with error and all details.

     

    Thanks

    Hardesh

  • BFlow Profile Picture
    34 on at

    I think my problem is the first item in the Apply to each ("Select an output from previous steps"). In the example, it shows "List of Response...". Thats not a dynamic content piece I've ever seen (and on the face of it, wouldn't the Get Response Details have to come first in order to get a list of responses anyway?!?).

     

    What I've been putting in there instead is the multiple choice question from the form, and the error is telling me that is not an array.

     

    Capture2.PNG

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @BFlow 

     

    Now share your action details " format output......6" with screen. So that i get to know that what are you passing in loop?

     

    As error clearly said expression is string it must be of collection type like array.

     

    Thanks

    Hardesh

  • BFlow Profile Picture
    34 on at

    Yes, going by to code referenced by the error (@outputs('Get_response_details')?['body/re275778528fd421da8e51ae202340ef2']), it seems to be referring to the When on Monday dynamic content I am putting at the start. I just dont know what else I could or should be using there.

     

    Capture3.PNG

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @BFlow 

     

     

    In your MS Form, what is type of question "when on monday" means- single text, choices etc. One suggestion, use compose just above the loop and supply same input "when on monday" and share compose output. In this way we will get to know what kind of value in "what on monday" is coming.

     

    Thanks

    Hardesh

  • BFlow Profile Picture
    34 on at

    The question on the Form is multiple choice (multiple answers allowed):

    formsquestion.PNG

    If I put a Compose right before the operation, and put that question in, here is the result from a test run where a person selected Morning and Afternoon as their answer:

     

    compose.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard