You’re offline. This is a read only version of the page.
Hi all,
after like 24 hours of trying to find a solution and an endless googling, maybe I will find the answer here.
I am trying to export the output from the attached picture to an excel, line by line.
If I do it manually (take and copy) it works. If I do it via export to excel, it gives me everything in ONE line ...
Could you please help?
I also tried converting the string to an array but I did not succeed.
The result should look like the output in the second picture.
Thanks!
Michal
Are you splitting the string into array using the expression below:
Share
Report
All responses (
Answers (
1,650
split(outputs('input'),decodeUriComponent('%0A'))
I did test on my end and was able to split the string into array as shown in screenshot below. Within Apply to Each, you need to add an action to write a row into Excel. As you can see in screenshot, the Apply to Each is running 6 times, one for each line in the initial string.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
