Convert From multireply string into a valid array

(2) Share

Report

Posted on by Gaetan

Hello,

I getting headach converting a string into a array with Flow in order to iterate for each items.

I trying trigger a MS Flow for when a MS Form is submited. The Form contains a multiple options question. My issue is I can't found a way to itterate for each option selected.

Here is the question where I selecte Options and 3:

Here is my flow:

Note that the compose action has no real puposes it is just to visualise the output for the question.

This is generating an error

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@@createArray(@outputs('Compose'))' is of type 'String'. The result must be a valid array.

The output of the question reply is a string like ["Option 1","Option 3"]. How can I convert this into a valid array?

Many thanks in advance,

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Gaetan,

The output of the first Compose is already an Array.

Please take a try to add the compose Output directly without the formula, see if it would work for the Apply to each.

Besides, if you would like to have the array elements into one string, then we need to use Join in another Compose, the formula should be:

"@join(outputs('Compose'),',')"

Regards,

Michael

Was this reply helpful? Yes No
Gaetan 24 on at

Like (0)

Report
Copy link

Link copied!
Hello @v-micsh-msft,

Thanks for your feedback.

I tryiedto passthe compose output directly to the Foreachbut it fails:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose')' is of type 'String'. The result must be a valid array.

Seems like it is concideredas a string and not array.

What do you think?

Was this reply helpful? Yes No
Verified answer

Gaetan 24 on at

Like (3)

Report
Copy link

Link copied!

I was finally able to have this work. In the the Apply to each output from previous steps i'm converting the string array from Form reply into a JSON. This is generating a valid array that the Apply to each will iterate through.

Was this reply helpful? Yes No
sklein09 4 on at

Like (1)

Report
Copy link

Link copied!

Can you please show what your expression was to correct this?

Was this reply helpful? Yes No
danishpowerapps 66 on at

Like (0)

Report
Copy link

Link copied!

Forms multiple choice --> Sharepoint List look no further: John Liu has a better solution:
https://www.youtube.com/watch?v=dNZydb1QH4o&ab_channel=JohnLiu

Was this reply helpful? Yes No
MaxBarrass 18 on at

Like (0)

Report
Copy link

Link copied!
Just create an expression and do this

json(outputs('Get_response_details')?['body/r555abb6d4c254b339a5731eda30d9c3e'])

Was this reply helpful? Yes No