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

MS forms to Word Template - Question has multiple answers

Hello!

 

I am busy working on a checklist for company vehicles.

The options in my form are as follows.

 

In Order

Out of Order

Other(where we can specify what exactly is the issue)

 

I have setup a flow with a word template which then creates a PDF file from the word template.

 

The issue I am experiencing at the moment is that my flow is set to get response details from Forms. However I only have 1x question response field.

 

I am looking at splitting the Other part to a feedback field.

 

How would I do this?

 

checklist flow1.PNGChecklist template1.PNG

3 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi @Dunizax,

 

Could you please tell me how to put each record into the template?

You can share the MS Form survey template.

Currently, the Populate a Microsoft Word template support input repeat records, you could refer to this blog to learn how to use it:

https://flow.microsoft.com/en-us/blog/intermediate-flow-of-the-week-create-pdf-invoices-using-word-t...

Best Regards,
Community Support Team _ Lin Tu
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

Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi @Dunizax,

 

The detail of the Populate a Microsoft Word template action:

Annotation 2019-09-11 173849.png

Best Regards,
Community Support Team _ Lin Tu
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

Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi Dunizax,

 

The ID you can view in the dynamic content.Annotation 2019-09-12 093317.png

 

 

 

You can get the Question ID to follow these steps:

Step 1: input a string function (for instance) in the Expression window.

Annotation 2019-09-12 093349.png

Step 2: Select the question.

Annotation 2019-09-12 093426.png

Step 3: click the question.

Annotation 2019-09-12 093449.png

Best Regards,
Community Support Team _ Lin Tu
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

7 REPLIES 7
Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi @Dunizax,

 

Could you please tell me how to put each record into the template?

You can share the MS Form survey template.

Currently, the Populate a Microsoft Word template support input repeat records, you could refer to this blog to learn how to use it:

https://flow.microsoft.com/en-us/blog/intermediate-flow-of-the-week-create-pdf-invoices-using-word-t...

Best Regards,
Community Support Team _ Lin Tu
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

Dunizax
Level: Powered On

Re: MS forms to Word Template - Question has multiple answers

Good Morning @v-litu-msft ,

 

Thank you for the reply.

 

Please find below template document I am using.

 

Below is also the Form that I use.

 

What I would like to do is when "In order" is used it should populate only "in order" into the condition field. When it is "out of order" it should then also populate the "Issue" field with the feedback provided in the other field.

 

Forms multiple question.PNGTempalate.PNG

Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi @Dunizax

 

Cause the number of columns for the Checklist, it will be a huge Flow you final create.

 

This is the document template according to you provided, and the begin of create the Flow, I renamed each text content control:Annotation 2019-09-11 162210.png

Then I create the Flow:Annotation 2019-09-11 162634.png

Step 1: Initialize an array variable to store the response of Spare Tire condition.

Step 2: Set Spare Tire condition variable. Cause the output is a string, not an array, so we need to remove these characters '[', ']', '"', with the help of replace() function, then use the split function to create the array according to the string.

Original string:

 

[\"I am a robot\",\"Out of Order\"]

 

 

After replace() function:

I am a robot,Out of Order

After split() function:

[
"I am a robot",
"Out of Order"
]

 

The code is the unique code of the answer, you can get it from the dynamic content:
Annotation 2019-09-11 163003.png

 

 

The result of the Flow run I create a file it look like as below:

Annotation 2019-09-11 161721.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi @Dunizax,

 

The detail of the Populate a Microsoft Word template action:

Annotation 2019-09-11 173849.png

Best Regards,
Community Support Team _ Lin Tu
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

Dunizax
Level: Powered On

Re: MS forms to Word Template - Question has multiple answers

Hi @v-litu-msft ,

 

thank you very much for your detailed information and time!

 

I am going to try this out and let you know should there be any issues.

 

Community Support Team
Community Support Team

Re: MS forms to Word Template - Question has multiple answers

Hi Dunizax,

 

The ID you can view in the dynamic content.Annotation 2019-09-12 093317.png

 

 

 

You can get the Question ID to follow these steps:

Step 1: input a string function (for instance) in the Expression window.

Annotation 2019-09-12 093349.png

Step 2: Select the question.

Annotation 2019-09-12 093426.png

Step 3: click the question.

Annotation 2019-09-12 093449.png

Best Regards,
Community Support Team _ Lin Tu
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

Dunizax
Level: Powered On

Re: MS forms to Word Template - Question has multiple answers

Hi @v-litu-msft 

 

thank you!

Helpful resources

Announcements
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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,948)