Embedding HTML code in Power Automate table

Question

question

NestorHolynskyj-2689 asked Dec 21, '21 DennisKuhn-3073 commented May 2, '22

Embedding HTML code in Power Automate table

I have a Power Automate flow that uses the "Create HTML Table" function as one of its steps. One of the fields in the table is a URL address. The latter can be quite long and makes the display of the table in the email to which it is sent quite crowded. The link appears as the full address. I would prefer to have a label displayed so that when it's clicked the reader gets sent to the underlying link. I know how to create a labeled link in a regular HTML page. However, I'm trying various ways to embed the labeled URL into the table created by Create HTML Table. For example, I've something like this: <a href="https://google.com">Click for Google</a>. The table that is generated shows the link but ignores the label section.

Any advice?

sharepoint-workflow

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenXu-MSFT · Dec 22, 2021 at 05:29 AM

@NestorHolynskyj-2689 ,

To understand you better, could you please share here a sample screenshot of the action Create HTML Table on your end?

0 ·

NestorHolynskyj-2689 · Dec 22, 2021 at 01:50 PM

Here you go... I'm showing the two related steps: the Select Fields step (note the "Email" field that is pulled from Dynamic Content) and the next step which creates the HTML table. FWIW, I've also included a text file with the code behind the Select Fields step.
Thanks in advance for you help.

159717-code-peek.txt

0 ·

screen-shot-2021-12-22-at-84327-am.png (52.3 KiB)

code-peek.txt (559 B)

Answer 1 · 2021-12-27T01:47:51.367Z

AllenXu-MSFT answered Dec 27, '21 DennisKuhn-3073 commented May 2, '22

Hi @NestorHolynskyj-2689 ,

The key is that ‘<’ and so on are reserved characters in HTML, they are escaped as text, so they cannot be recognized. Finally I solved this issue by using expression replace(replace(replace(body('Create_HTML_table'),'<','<'),'"','"'),'>','>') here:

An email I got from above flow:

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

image.png (83.3 KiB)

image.png (39.0 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DennisKuhn-3073 · May 02 at 11:43 PM

Awesomestness, thanks a lot for sharing ;-)

0 ·

Answer 2 · 2021-12-27T14:44:30.937Z

NestorHolynskyj-2689 answered Dec 27, '21

Outstanding! You absolutely rock! Saved me days of frustration... Thanks

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question