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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,605)