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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Convert Data Table to ...
Power Automate
Answered

Convert Data Table to Text

(1) ShareShare
ReportReport
Posted on by 15
Hello community,
 
I'm struggling with something that should be simple but I can't figure out how to handle it.  I have an sql query where I want to send the results in an email.  I I tried converting a data table to CVS and Join Text but but both result in the same long string.  Is there a trick to getting the line breaks when converting a table to text? Any help would be immensely appreciated. 
 
 
 
 
This is how the email appears
 
 
I have the same question (0)
  • Verified answer
    Sayan Profile Picture
    818 Moderator on at
     
    The Flow you have shared that is little bit confusing. can you please share the flow step by step and if possible, please share also the input data so that I can work on it.
     
    Solution:
     
    I have also tried the same, but I get the correct output.
     

     
    I have also shared the flow.  Please the details clearly so that I can help u on this
     
    --------------------------------------------------------------------------------------------------------------------------------------------------

    If my suggestion helps you, please gives it a Like and Marks as a Solution. Which motivates to solve more problems.

     

    Thanks,

    Sayan Patra

    RPA Developer

  • JeannieF Profile Picture
    15 on at
    Hello,Thanks for your response.  I cleaned up the flow so that it mimicks your and still getting the same result.  I've also updated my power automate desktop version to the latest and have tried running the flow from two different machines.
     
  • Sayan Profile Picture
    818 Moderator on at
    Hey @JeannieF apologize for late response can you please confirm is the issue is resolved or still have the issue?
  • LF-20011939-0 Profile Picture
    2 on at
    Emails are formatted as html so that may be something you consider. 

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard