Unanswered

Remove line breaks in Variables from SQL Database in Desktop Flow

(0) Share

Report

Posted on by Cloudadm

Hello all,

I am currently having the problem that when I create variables out of my MySQL database they have line breaks later in the desktop flow. The line break is only visible in the input details of the desktop flow activity.
This does not allow me to determine the distinguished name in AD.
Does anyone have a fix or workaround for this problem?

Many greetings

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

If you want to fix this in the desktop flow, try using Replace text with regular expressions enabled and replace \r\n with %""% (indicates that it will replace it with nothing - an empty string).

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Cloudadm 4 on at

Like (0)

Report

Unfortunately, no.
\r\n is not replaced. Can you possibly send a screenshot of exactly how you filled in the "Replace text"?

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Make sure that you enable regular expressions:

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No