cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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
Community Support

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

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
Community Support

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
Community Support

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

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

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.

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

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
Community Support

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

Hi @v-litu-msft 

 

thank you!

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,788)