Answered

Choice Pills Not Displayed

(1) Share

Report

Posted on by RC-08071448-0

I have a Microsoft Form with multiple choice options where user can select multiple and add an 'other' option. Once the form is submitted it is Power Automated to update to a specific Sharepoint List. The list contains the same choices in 'Pill Display', however anything added from the form displays with [choices].

The list column is set to: choice type and can add values manually. With the display choice being: drop-down menu, allow multiple selections.

Power Automate is set to 'create item' and associated to the specific question.

How do I fix this?

Categories:

Building Power Apps

image.png

I have the same question (0)

All responses (4)

Answers (1)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@RC-08071448-0 Hi,

I think you assigned the whole value from Form result to Value 1.

1. Add a Compose for example after 'Get response details',

json(first(Split(outputs('Get_response_details')?['body/ChoicesFields'],';')))

This will generate an array value from the Form.

For example.

[

    "Apple",

    "Peach",

    "Banana"

]

2. Then, add a 'Select' step.

From= outputs('Compose')

Map: left type Value, right type item().

The output is ( my example):

{ "body": [ { "Value": "Apple" }, { "Value": "Peach" }, { "Value": "Banana" } ] }

3. Then assign the select output to your multiple choice column

click the little “T” (toggle) icon so the field switches to single array input.

Feel free if you have any questions.

Was this reply helpful? Yes No
RC-08071448-0 8 on at

Like (0)

Report

@stampcoin

At compose I am receiving the following error when entering:

json(first(split(outputs('Get_response_details')?['body/ChoicesFields'],';')))

InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@RC-08071448-0 Hi,

You have to use your own field from your form,

outputs('Get_response_details')?['body/re8f47033dca74b0c9b6252f302df011d'], this is from my example,

you may have different one.

see below , from dynamic content, find your choices field and select it .

hope this make sense to you.

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@RC-08071448-0 Hi,

Did you get chance to check this ?

Was this reply helpful? Yes No