cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD20
Level: Powered On

Populating Submissions from Microsoft Forms with Word Online Connector

Having some trouble with output on this--anytime there is a quote inputted in Microsoft forms or when there a multi-option question, I get this: ["Productivity","People"] Is there any way to fix this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Populating Submissions from Microsoft Forms with Word Online Connector

Hi @GD20 ,

 

I did a test on my side, you could try to use the following Expression to remove the escape character.

Expression reference:

replace(replace(replace(body('Get_response_details')?['r38615ff28b0a4793ae066b777f21bf7b'],'","',','), '["',''), '"]','')

Image reference:

28.PNG

Flow run history:

29.PNG30.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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
Highlighted
Community Support Team
Community Support Team

Re: Populating Submissions from Microsoft Forms with Word Online Connector

Hi @GD20 ,

 

I did a test on my side, you could try to use the following Expression to remove the escape character.

Expression reference:

replace(replace(replace(body('Get_response_details')?['r38615ff28b0a4793ae066b777f21bf7b'],'","',','), '["',''), '"]','')

Image reference:

28.PNG

Flow run history:

29.PNG30.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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

GD20
Level: Powered On

Re: Populating Submissions from Microsoft Forms with Word Online Connector

That worked, perfectly! Thank you so much for your help. 

Maria_Geek
Level: Powered On

Re: Populating Submissions from Microsoft Forms with Word Online Connector

@GD20if MS Flow will only take a template with plain text fields, how did you setup for showing the multiple choices made?  Can you share your template?

 

I need to take in multi-choices, then indicate only the ones chosen on the list.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,777)