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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Cannot export line by ...
Power Automate - Building Flows
Unanswered

Cannot export line by line to excel (using string)

(0) ShareShare
ReportReport
Posted on by Michalky

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

 

outputs2.PNG
outputs.PNG
I have the same question (0)
  • Mitanshu Profile Picture
    Mitanshu 1,644 Moderator on at
    Re: Cannot export line by line to excel (using string)

    Are you splitting the string into array using the expression below:

    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.

    happyume_0-1688837721675.png

     

    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.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans