Unanswered

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)

grantjenkins 11,063 Moderator on at

Like (0)

Report
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 (0)

Report

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 (0)

Report
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 (0)

Report

you are immense!

Was this reply helpful? Yes No
clarkyb on at

Like (0)

Report

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