Unanswered

Append multi-choice answer into individual variables

(0) Share

Report

Posted on by george-lh

Hi all,

I am trying to find a way to append a multi choice MS forms output, then mapping each output to a unique variable that i can use to populate a MS word form.

EG: Output//

"r471129aa16ef4dcdbcdd56d4b7e2863b": "[\"Option 1\",\"Option 2\",\"Option 3\"]"

Desired outcome

Variable1=Option 1

Variable2=Option 2

I can then use these variables to populate the individual word form with the appropriate variable values.

Everything i have tried until now has been to no avail. I can populate the form no problem its just mapping the outputs.

Any help would be massively appreciated.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Hi @george-lh ,

You can convert the output to an array by the following formula:
Then get each value by index, such as variables('arrayName')[0].
split(slice(outputs('Get_response_details')?['body/r471129aa16ef4dcdbcdd56d4b7e2863b'],2,-2),'","')

Test:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
george-lh 12 on at

Like (0)

Report

Deleted response

Was this reply helpful? Yes No
george-lh 12 on at

Like (0)

Report
Hi,

Thanks for your response, the solution works but has got an issue.
I have created the following variable expressions to represent the upto 4 options that can be defined for this example.

variables('test')[0]
variables('test')[1]
variables('test')[2]
variables('test')[3]

If i then test the flow with all 4 answers it works.
However running a test with 3 or less options selected returns an error

The template language expression 'variables('test')[3]' cannot be evaluated because array index '3' is outside bounds (0, 2) of array

Due to me mapping these variables to a word form field if I run a test with options 2/3/4 selected, those variable values change so mapping the output gets mixed up.

What would you suggest with this ?

Thanks again, George

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @george-lh ,

Has the issue been resolved? I think you can create an array containing all the answers first, then compare this array with the outcome array, and set the non-existing items to null.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
george-lh 12 on at

Like (0)

Report

HI, Its not resolved as of yet.
Do you have an example of this at all? Power-automate is pretty new to me so not quite up to speed yet.

Regards
George

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Was this reply helpful? Yes No
george-lh 12 on at

Like (0)

Report

Hi, not sure if you noticed you posted a blank response.

Kind regards
George

Was this reply helpful? Yes No
Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @george-lh ,

If you have not yet resolved the issue, you could refer to the following method:
Array 'arr' remains unchanged,
Set the array 'answers' to include all answers,
The array 'result' is what we want.
In this example, the unselected answer will be displayed as "null".

Test:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
george-lh 12 on at

Like (0)

Report

Hi all,

Just wanted to revisit this as i have been trying to utilise multi option with a other field.
Due to not being able to define the random value other can be, i have tried to append a variable value, then append with actual value after its ran, however i can get it to play nicely.

Could anyone help at all?

Thanks
George

Was this reply helpful? Yes No