Unanswered

Flow automatically adding extra backslash to string

(0) Share

Report

Posted on by JenLavery

Trying to send an email listing enrolled students to course tutors with their learner plans, but when adding the hyperlink field from the SQL table, Power Automate is adding an extra back slash at the beginning and end of the hyperlink, breaking the HTML tag. This occurs inside a ForEach loop. I've tried using replace, but that did nothing. I also tried using concat to no effect, expression as follows:

concat('<a href="', item()?['hyperlink'], '">', item()?['student_forenames'], ' ', item()?['student_surname'], '</a>')

Any ideas on how to get around this odd quirk?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

OliverR-82 619 on at

Like (0)

Report
It's adding the backslash to escape the double quotes around the URL because there are already double quotes at the beginning of that string. Have you tried replacing the double quotes in your Select action with single quotes? That would give you a link like below, and that should still work.
<a href='https://www.yourlink.com'>this link should still work</a>

Was this reply helpful? Yes No
JenLavery 61 on at

Like (0)

Report

Thanks! I thought that might be it. Switching has removed the \ from the output.

However, it still does not translate to a hyperlink on the 'Create HTML Table' function. Looking about, this may be a problem with that specific connector. It doesn't like HTML tags in the table fields.

Tried putting the HTML tags directly in the connector, but that doesn't seem to be doing the trick either. Don't suppose you've been able to get around that as well? 😅

Was this reply helpful? Yes No
JenLavery 61 on at

Like (0)

Report
Found an article explaining the Create HTML issue. When getting the output for create HTML for the email, I had to use the following expression to make the hyperlink tags work:
replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')

Helpful article for the Create HTML table link issue

Was this reply helpful? Yes No