web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Populate a Word Templa...
Power Automate
Unanswered

Populate a Word Template - Text Formatting

(0) ShareShare
ReportReport
Posted on by 8

Hello,

 

I set up a flow that takes responses from MS Forms and uses the Populate Word Template action from the Word Online Connector to populate the responses into a Word document. The issue I'm running into, is that if someone fills out a text answers that contains an apostrophe, the text box will display ''' instead of an apostrophe on the Word document. It will also do the same thing for quotes and ampersands. Has anyone else dealt with this issue?

 

2-28-2019 12-43-52 PM.png

Categories:
I have the same question (0)
  • AlanPs1 Profile Picture
    2,471 on at

    Hi @FlowUser2 , thank you for your post!

    Have a look below at this link and the images below:Capture-251.png

    The "HTML to text" connector does what you ask, you'd just need to target the values you are looking for in your form output beofre populating your template.Capture-252.png

    If you have found my post helpful, please mark thumbs up.

    If this post has solved your problem, please click "Accept as Solution".

    Any other questions, just ask.

    Thanks, Alan

  • FlowUser2 Profile Picture
    8 on at

    Hi @AlanPs1, thank you for your reply and sorry to take so long to get back to you. I tried what you suggested but unfortunately it did not affect the output. The text being input appears clean, it's only when the data appears on the word document that the formatting is off. I set up a test flow so that you can see what I mean:

    Flow setup:

    flow1png.jpg

     

     

    flow2.jpg

    flow3.jpgflow4.jpg

    The is the output on the Word Doc:  flow6.jpg

  • AlanPs1 Profile Picture
    2,471 on at

    Hi @FlowUser2 

    Thank you for doing that test, it was really helpful and I have recreated it and get the same issue. I am working with ways to try and get round it but it may be a limitation at present. So, leave it with me, unless of course another doc format would work and maybe we could look at approaching it another way.

    Thanks, Alan

     

  • KeringStoreSupp Profile Picture
    19 on at

    Hello guys,

    I am in the same situation.

    When trying to populate a Microsoft Word document with fields coming from a MS Form, I get " in the Word Document. I am trying to subsitute the chars with @replace formula, but it's not working.
    The only "workaround" for now is to strip the bad chars.

    I think this is something that has to deal with XML and the Word Template.

    Those chars in the template fields should be escaped somehow maybe?

     

    Any suggestions?

    Thanks for your help.

     

    Andrea

  • FlowUser2 Profile Picture
    8 on at

    Unfortunalty, I believe it's because only the plain text content control is supported. I tried a number of manipulations on the Flow side, but because the text is normal until it hits the Word doc, everything looks fine as far as Flow knows.

     

    I had to move on to other things, so like you I am just using nested replaces to remove the unsupported characters and replacing '&' with 'and'. Not the most ideal or professional looking option, but until the connector is updated to support rich text content controls there doesn't appear to be anything else that can be done.

     

    If you end up figuring something out, I would love to hear about it. I'll update this thread is well if I end up coming across anything.

     

     

  • KeringStoreSupp Profile Picture
    19 on at

    Hello,

    the only workaround I figured out is to replace the " ' " carachter with " ` " when populating the Word document in the bloc "Popoluate a Microsoft Word Template (Preview)"

     

    replace(body('Get_response_details')?['ra0814f15501a46c7bb0cd158bbd39507'],'''','`')
     
    2019-05-17_115738.jpg
     
  • gazzo1967 Profile Picture
    1,151 on at

    @KeringStoreSupp 

    Hi 

    Where does this solution fit into the actual flow? 

    I have the same issue 😞

    Gary

  • KeringStoreSupp Profile Picture
    19 on at

    Hello,

    it goes in the bloc of instructions: "Populate a Microsoft Word Template"

     

    2019-08-21_163041.jpg

     

  • MTrindade22 Profile Picture
    2 on at

    Hello, 

    Has anyone every figured out how to solve this issue? My text is in Portuguese, and it's even worse when considering characters such as "ç". Thanks in Advance!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard