cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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)

 

flow Screesnshot2.PNGflow Screesnshot1.PNG

 

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\"]"

FlowCanteen2.PNG

 

And today the response data is in this format:

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

 

flow Screesnshot3.PNG

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:
FlowCanteen.png

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

Thanks.
Vincent

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Solution Sage
Solution Sage

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'),']','')

Capture.PNG

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

 
v-zhos-msft
Solution Sage
Solution Sage

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'),']','')

Capture.PNG

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.

View solution in original post

Anonymous
Not applicable

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.


Canteen Flow Final.png

kind regards
Vincent

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,144)