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:

Process Advisor

All responses (4)

Answers (0)

LF-20011939-0 2 on at

Like (0)

Report

Convert Data Table to Text

Emails are formatted as html so that may be something you consider.
Sayan 668 on at

Like (0)

Report

Convert Data Table to Text

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

Like (1)

Report

Convert Data Table to Text

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.
Suggested answer

Sayan 668 on at

Like (2)

Report

Convert Data Table to Text

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