Answered

How do I remove the quotes and [ ] from multi choice questions when populating a word file

(0) Share

Report

Posted on by clarkyb

Hi all

I am really hoping for some help. I have a MS Form which has 4 sets of questions which are multi choice. I then want to populate the Word template to show the selection. I have been able to set this up.

I am however struggling to remove the @quotes and [ ] signs. Is there a way I can remove these from showing in the word file?

Any help would be pretty amazing! I have included pictures to demonstrate. Thanks

All responses (5)

Answers (1)

clarkyb on at

Like (0)

Report

Re: How do I remove the quotes and [ ] from multi choice questions when populating a word file

Sorry I have came up with a small issue. When the form question is branched off (therefore not completed). I keep getting a null error. Is there something I can change on the join? It is currently
join(json(outputs('Get_response_details')?['body/r200a521530d34a3a9d833ec47cfc6c32']), decodeUriComponent('%0D%0A')) and I drop it into the populate a ms word field

any help would be fab . Thanks
clarkyb on at

Like (0)

Report

Re: How do I remove the quotes and [ ] from multi choice questions when populating a word file

you are immense!
Verified answer

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: How do I remove the quotes and [ ] from multi choice questions when populating a word file

You can add the full expression directly into you Populate a Microsoft Word template or would add it into a Compose.

If you wanted to use a Join action, you would need to split the expression into the following:

//From json(outputs('Get_response_details')?['body/rbffbec37339a4b4eba59abec9635dcbb']) //Join with decodeUriComponent('%0D%0A')
clarkyb on at

Like (0)

Report

Re: How do I remove the quotes and [ ] from multi choice questions when populating a word file

Thanks for response - much appreciated. I'm struggling though - is this how the flow would look? I keep getting error messages
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: How do I remove the quotes and [ ] from multi choice questions when populating a word file

You can use the following expression to join each of the answers with a new line and carriage return. You'll need to ensure your Word document Text field is set to allow carriage returns too.

//You would just need to insert your multiple choice field in place of what I have join(json(outputs('Get_response_details')?['body/rbffbec37339a4b4eba59abec9635dcbb']), decodeUriComponent('%0D%0A'))

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.