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?
Solved! Go to 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.
Please check out the screenshots below and try it out. Please let me know the results of your tests.
Regards,
Fausto Capellan, Jr
Proud to be a Flownaut!
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.
Please check out the screenshots below and try it out. Please let me know the results of your tests.
Regards,
Fausto Capellan, Jr
Proud to be a Flownaut!
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!
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
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
Proud to be a Flownaut!
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.
hey @faustocapellanj ,
I just tried this solution and unfortunately it did not work, any other ideas?
Never mind, found this solution which works:
https://powerusers.microsoft.com/t5/Building-Flows/CRLF-in-quot-Create-File-quot/td-p/155693
User | Count |
---|---|
73 | |
50 | |
48 | |
27 | |
18 |
User | Count |
---|---|
27 | |
27 | |
25 | |
20 | |
19 |