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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
clarkyb on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for response - much appreciated. I'm struggling though - is this how the flow would look? I keep getting error messages

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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')

Was this reply helpful? Yes No
clarkyb on at

Like
a
(0)

Report
Copy link

Link copied!

you are immense!

Was this reply helpful? Yes No
clarkyb on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No