Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Seperating Text Into Rows from Form response to Word Template

(1) ShareShare
ReportReport
Posted on by 55

Hi all,

 

I am trying to take a multiple choice answer from a form, re-format this (to remove the various brackets etc), then split this into separate rows for entry into a word template. Currently, everything is working, but it is not entering into the word template as separate rows of text.

 

So. To format the response from the form, I have a compose step as below:

CG83_0-1720082332569.png

I then use the output of this step to populate the word document, but this enters into the template as shown below:

CG83_1-1720082430329.png

 

Clearly, the multiple answers are joined together which makes it very difficult to read. I would like this to be split into separate rows by the ,

 

I have tried using the split function when entering this into the Word Template with the expression

split(outputs('PPE'),',') but this still enters it as one string. 
 
If anybody could help me to establish what I am doing wrong then that would be great

 

Categories:
  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Seperating Text Into Rows from Form response to Word Template

    Can you share a screenshot of the flow?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard