Flow + Forms: Format of Response Data is always reset after closing the flow

[Anonymous]

Hey Everybody,

we have created an Microsoft Forms Survey, where the employees can book canteen service for events. Based on this data we wanted to build a flow which sends automatically the information in an email to the canteen team. They can either cofirm or "decline" the order. The flow works fine so far exept from one thing: The values we've entered in the switch cases are in this format: "[\"Essen in der Kantine\"]" (Results of the multple choice question in forms). When we save & test the flow everything works fine. But when we close the editor, the values in the switch fields are always reset to this value: ["Essen in der Kantine"]. (see screenshot)

Another Problem is, that the format of the response data changes. Yesterday it was in this format: 

"[\"Essen in der Kantine\",\"Kaffeepause am Vormittag\\n\"]"

And today the response data is in this format:

"[\"Essen in der Kantine\",\"Kaffeepause am Vormittag\"]"

I don't know what that means and how I can get this flow working automatically and by itself.

Here you can see our Flow:

Does anyone know why this is happening and what we can do about it?

Thanks.
Vincent

[v-zhos-msft · Accepted solution]

Hi @Anonymous ,

I have made some tests on my side.

I suggest you use the replace function to replace the '[]' of the response value.

I have made a flow for your scenario, please check it for a reference.

The expression in Compose is:

replace(body('Get_response_details')?['r6944a0257ae344fc8c35bd2a7cf1363e'],'[','')

The expression in Compose 1 is: 

replace(outputs('Compose'),']','')

Best Regards,

Community Support Team _ Zhongys

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

[Anonymous]

Hi there,

thanks a lot. We had to replace the 'r6944a0257ae344fc8c35bd2a7cf1363e' token with the one from our response data. We also putted a compose_3 step afterwards to replace all the " signs. But now everything works. 

Thanks for your fast and competent help.

kind regards
Vincent