Unanswered

Microsoft Forms text question with long answer in Power Automate flow

(0) Share

Report

Posted on by AK89

Good morning folks.

I am building a flow that is triggered by filling Microsoft form. My choice of question is text with long answer. A person filling up the form has to put information that looks like this

AB1234567 BJ 3 16A

ACB1234567 BK 32H

and so on.

When I try to populate word Document in Power Automate with this information, instead of list, I am getting all the data in one line that looks like this

AB123456 BJ 3 16A ACB1234567 BK 32H.

Is there any expression that splits the information into the lines as it was entered in the Form initially. If not, does anyone know any alternative way of doing it.

Thank you very much.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@AK89

Okay, first question are you going staright from the form submission to that of populating the word template.

Or what about asking the person to fill out the long fieild with a commar between each item in the long text field. You could then split on the commer and add a carridge return as a compose. I am not sure if the below will help you out:

https://powerusers.microsoft.com/t5/Building-Flows/Formatting-for-a-compose-output/td-p/84708

I am not sure this is going to help you.

Regards,

Andrew

Was this reply helpful? Yes No
AK89 49 on at

Like (0)

Report
Copy link

Link copied!

Hello Andrew
Can I please share with you how it looks

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@AK89,

Thanks for the photos, it would really help to have you use the snip feature and add them to the post that way so I can read things. That is how most people do this.

Also look at this below:

https://powerusers.microsoft.com/t5/Building-Flows/Word-Template-not-populating-multi-line-info-from-form/td-p/1842783

Regards,

Andrew

Was this reply helpful? Yes No