Line Break in Create File Output

[Kav]

Hi everyone,

I have a flow which has an action to 'create a file' on a server, as seen here in this screenshot:

https://drive.google.com/file/d/1PoGn3SU-0rvnU1m2KUTJ6KAp7-BuHLdc/view?usp=sharing

Problem is the output text is all joined together in a single line, even when I have hit enter to put each field on a separate line, it does not put a line break in the output text file. How can I achieve this?

PS; we cant attach files in this forum?

[faustocapellanj · Accepted solution]

Hi @Kav

Looking at the screenshot, I will assume you are trying to create a file from responses submitted in a Microsoft Forms. I tried to replicate your scenario, and the steps below worked for me. Perhaps you can follow them and report back the results.

1. For the trigger, I added a Microsoft Forms - When a new response is submitted. I selected the respective Form Id from the dropdown.
   
2. For the next step, I added a Initialize variable, which I renamed to Initialize responseText Variable. I am using this variable to add all the data needed from the form responses to create a text file.
   
3. Since there might be multiple form responses, Flow will automatically add an Apply to each action once you add a Microsoft Forms - Get response details action and select the Form Id and Response Id.
4. I followed the Microsoft Forms - Get response details action with an Append to string variable action. In this action, I select the variable name from the dropdown and in the Value field, I entered all the fields I need from the form to create the text file.
   
5. Then outside the Apply to each action, I added a OneDrive - Create file and a Create File Azure Storage actions and the file was created with all the line breaks as formatted in the Append to string variable action. In the screenshot below, you can see I used the value from the variable in the File Content field.
   
   
   

Please check out the screenshots below and try it out. Please let me know the results of your tests.

Regards,

Fausto Capellan, Jr

[Kav]

Wow, thanks for the detailed response. I followed your flow steps and the problem still appeared.

Then I realised the problem, it was actually notepad that was showing the text incorrect, the data was indeed on new lines when you opened it in wordpad, but for some reason opening in notepad showed everything on a single line. Odd, but sorted now, thanks!

[Talha]

Hi@faustocapellanj  @Kav,

Thanks for your post its saves my time.

Is there any way to bring a New Line in NotePad(.txt) file ??

Because i am Reading this Notepad with VBA coding, VBA Takes all the file content as a single line.

if i Open manually and Press Enter button, then VBA read the Notepad content as seperate line.

so is there any possibilites to bring New line in NotePad file.

Thanks

[faustocapellanj]

Hi @Talha 

If you want to add the new line to a text file using Flow, you can insert the text below where you want the line break:

"\r\n"

Those are the characters used for line breaks. Please try it and let me know.

Regards,

Fausto Capellan, Jr

[Kav]

Interesting! I might try this solution out.

I figured the issue was the new line character that Flow was using is different from what Notepad uses, as the file when opened in anything other than notepad, would appear OK on separate lines.

[Kav]

hey @faustocapellanj ,

I just tried this solution and unfortunately it did not work, any other ideas?

[Kav]

Never mind, found this solution which works:

https://powerusers.microsoft.com/t5/Building-Flows/CRLF-in-quot-Create-File-quot/td-p/155693