Lose text formatting from Microsoft form to Word

[Keenz]

Below is my flow that pulls the responses of a Form into a word template and emails it to the owner of the form response pulling out key information into body of email and attaching full response. Unfortunately both the email and the word document appear to lose the formatting of paragraphs of the long text answers that were inputted into the form. Is there a way to ensure the answer formatting is kept when pulled across?

[Agnius]

First of all, this forum is meant for desktop flows, but your question is related to cloud flows. The correct forum to post questions like that is here: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows

Secondly, I would suggest that you provide more context and samples. What kind of formatting are you talking about? Can you provide screenshots?

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[Keenz]

Hi Agnius, thanks for your response, I will try the other forum if I don't have any luck here.

An example of the issue is here below:

Input into Microsoft forms:

Email Output

Word Document output

Does this help further clarify the issue?

Thanks,

Adam

[Agnius]

Can you share the raw inputs from the flow run?

[Keenz]

Apologies i'm not quite sure what you want, is it this?

[Agnius]

Nope. When you open your flow, there should be a view of previous flow runs available. Open one of those and then expand the trigger action, and see the outputs of it.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[Keenz]

I've pulled out the section from my above example:

<strong>The key takeway messages from my engagement are:</strong><br>
<br>
Testing Here
Testing New Line
Another New Line<strong><br>
<br>

Interestingly still kept the formatting at this point.

[Agnius]

This is really not what I meant. When you open your flow, there will be an overview view that has the 28-day run history at the bottom of the screen. Will look somewhat like this:

Click on the timestamp of one of these, to see the run details that should look somewhat like this:

Then click on the trigger action to see its outputs. And copy that here.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[Keenz]

Apologies for the delayed response, is this the bit you meant?

{

  "responder": "xxx",

  "submitDate": "7/18/2023 2:06:18 PM",

  "rfb5bf452eefe4f8daaa202904ae55a58": "Test",

  "r576e99da60714ef99ba2a3d8a4c22a06": "Test",

  "r5d3f8f5c02d44eb1bcb0791c331a767e": "No",

  "rbd81a569bb5842b391970e0e87c7703d": "",

  "r45ffd07322b24728b5934697768961f7": "2023-07-18",

  "r933ccb76107c42529f5c0634f61b35fc": "",

  "rd2314f4fa6c64aa8a2f503d4beb132d0": "No",

  "r9e5c3708ad8e4f309ea514638a0b14b3": "",

  "r6e8f43a7ca37491cb7638c71dcbf27a9": "Testing Here\nTesting New Line\nAnother New Line",

  "r5c243bb4b9fc4561a27968f8e608d395": "Testing",

  "r5fea13b03877403aa8f36dfc52c2a861": "",

  "rfbb636a61c3a4beeb5ac9d27cf0166b0": "",

  "r5460c107870d493f9abdc3df636b222b": "",

  "r76c65c641abb4b7da732d9e719a95edf": "[\"Testing\"]",

  "rc74be7f82a5248b3bb3ae720db2e54b7": "",

  "rab4a5bc7a1254b78b55eb4e334dbf587": "",

  "r9aa14557976e4ddd9221659545145c14": "Test",

  "r6248d05454e243df88870b5954637c3b": "",

  "r137bc1eef8ff4d4cbf7b824ad0e125aa": "",

  "rc83d0d5ba4ad48b28d42226ff68296eb": "",

  "rf65c13378a3247f6b9a8bc6c83170fec": "1",

  "r0eb6fbd37f43466882893015d2c8f86d": ""

}

[Agnius]

Okay. It seems like it sends \n characters for newline. I would suggest trying the replace() expression to replace \n with a literal new line. However, you will not be able to pass a new line as inputs to the replace() expression directly. You will need to initialize a new variable of type string that contains nothing but a new line (press the enter key in the value field of the new variable) and then use that variable in the replace() expression.

Let me know if this solves your issue.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.