cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DLGross
Level 8

Unable to Format Link in a Table

I'm trying to retreive multiple items from a SharePoint list and send them as a table in an Email, one of the fields needs to be the link back the the list item. I have set Is HTML property of the Send an Email action to True and tried to wrap the value in an HREF tag, but it's not working. Can someone tell me what I might be doing wrong or suggest an alternative approach? 

WFwithLink.png

 

@Pieter_Veenstraany ideas?

Dean Gross

Office 365- MSCA
SharePoint - MCSE
Microsoft 365 Enterprise Administrator Expert
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Unable to Format Link in a Table

Hi Dean,

 

Have a look at chakkaradeep's post: https://www.chakkaradeep.com/2018/05/02/building-html-tables-in-your-flows/

 

He is doing exactly what you are trying to do.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Unable to Format Link in a Table

Hi Dean,

 

Have a look at chakkaradeep's post: https://www.chakkaradeep.com/2018/05/02/building-html-tables-in-your-flows/

 

He is doing exactly what you are trying to do.

View solution in original post

DLGross
Level 8

Re: Unable to Format Link in a Table

Thanks, that article was very helpful. 

Any idea why the Create Table Action does not parse HTML?

 

It would seem that this common scenario should be easier to implement. A typical business user should not have to hand code html .

Dean Gross

Office 365- MSCA
SharePoint - MCSE
Microsoft 365 Enterprise Administrator Expert
tommyly
Level 8

Re: Unable to Format Link in a Table

There's an older post on this forum that talks about how HTML tables encode Values (and I say the word 'Value' in context of the HTML Table's two custom columns: (1) Header and (2) Value).

It's my assumption that the developers intended the values to be a one-for-one (i.e. straight text) translation. For example, if a value was "<no value entered>", they would not want Flow to inadvertantly default to trying to translate that into HTML--the net result would be trying to translate that into an HTML tag when it really shouldn't.

So what ends up happening is that they take the text in the Value field and convert the characters that may have HTML carryover and encode those characters. For example, quote becomes "&quot;" (without the quote-symbols), greater than (">") becomes "&gt;", less than ("<") becomes "&lt;", and strangely enough... ampersand becomes ("&amp;"). As you can see, the pattern for these encoding is [ampersand][code][semicolon]. If you want to see what I'm talking about, create a variable and set the value to your HTML table--then you can see what your actual HTML table looks like.

The workaround is to Compose your HTML table and replace the encoded values with their true values. Doing this has potential for consequences (mentioned above); but if you don't anticipate receiving values in brackets or quotes, then this workaround should work fine.

You can see some great examples of this in the link I referenced above provided by @DougL .

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 412 members 4,363 guests
Recent signins:
Please welcome our newest community members: