Unanswered

Convert Data Table to Text

(1) Share

Report

Posted on by JeannieF

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Sayan 818 Super User 2025 Season 2 on at

Like (2)

Report

Hey @JeannieF

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

Was this reply helpful? Yes No
JeannieF 15 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Sayan 818 Super User 2025 Season 2 on at

Like (0)

Report

Hey @JeannieF apologize for late response can you please confirm is the issue is resolved or still have the issue?

Was this reply helpful? Yes No
LF-20011939-0 2 on at

Like (0)

Report

Emails are formatted as html so that may be something you consider.

Was this reply helpful? Yes No