Switch Action not working with Microsoft Forms Responses

[Aazza]

As per the attachments below the switch action i have implemented into my flow isn't working.

I have set the case names as the answers for Place of incorporation/establishment in my Microsoft Form. However when i run the flow it goes to the default case which is if no case contains a matching value. This is because there is brackets and " around the answer in the switch action after running the flow but i can't add the brackets or " in my cases.

[AndreaMondello]

HI Aazza,
I think you can try removing the brackets and quotes and such like so:

After your Get Response Details add a 
COMPOSE action with expression:
replace(outputs('Get_response_details')?['variables/Place of Incorporation'],'[','')

Then a second COMPOSE ACTION with expression:
replace(replace(outputs('Compose'),']',''),'"','')

And finally you need a THIRD COMPOSE to SPLIT the result like so:
split(outputs('Compose_2'),',')

NOW add an APPLY TO EACH step
and put your SWITCH in it!
Outputs('Compose3')
with the Output that of final Compose as the input for the switch. 


HTH

[Aazza]

Hi @AndreaMondello 

Thank you for the response, i have just attempted this and it is returning a flow run failed.

[AndreaMondello]

Aazza can you show me what is in your first Compose expression?

[Aazza]

As requested here is what is in compose 1, i copied and pasted the expression you gave me.

[AndreaMondello]

Actually, in your case, remove the 'variables/Place of incorporation/establishment' and use the dynamic content picker to choose your form value. Sorry about that. 🙂

[Aazza]

I have now made these changes and am now facing another error, this is to do with the compose action 3 now.

[v-LilyW-msft]

Hi @Aazza 

Has your problem been solved?

Please take a try with below screenshots:

Expression:

json(outputs('Compose'))

Test Results:

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Aazza]

Hi Lily,

Thank you for the response, unfortunately after trying it with the screenshots you have provided the flow is still not running correctly.

The options I have on my Microsoft Form are, Hong Kong, Singapore, China and Other and even though the expression result of the switch was China instead of the flow continuing to the China Case it has gone to the default case where if no case contains a matching value.

[v-LilyW-msft]

Hi @Aazza 

Please check if there is a space where the arrow points, if there is any space, please delete it and try again.

Best Regards.

[Aazza]

Hi Lily,

I have just checked and neither of them have spaces where the arrows are