cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD20
Helper I
Helper I

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
v-bacao-msft
Community Support
Community Support

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

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

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

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

Anonymous
Not applicable

@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.

If I may:

I am interested on dynamically figuring out the dynamicFileSchema "numbers", as seen in your screenshot for the Flow-History. (This is needed so I can specify the schema even If i don't hard-code the file and the schema thus does not get loaded in advance).

Any ideas / API calls I can make to get these IDs/"numbers" for a given file?

 

cheers,

JP

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (68,809)