cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Collector
Kudo Collector

Insert an href in an HTML table

Hi all,

 

I'm trying to insert a link into an HTML table to send in an email.  I am using an array variable to loop thru SP list items.  Then insert that array variable in the Create HTML activity.  However, I can't seem to get it to come across as a link but rather as a string.  See screenshots below.  Any one know how I can accomplish this?

Capture.PNGCapture2.PNG

 
 
 
7 REPLIES 7
Super User III
Super User III

Hi!
Had this problem also sometime ago. Already subscribed to this post, let's hope somebody else can suggest us a solution!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Microsoft
Microsoft

You may need to select the dynamic content "Link to item" instead of "ID" in Variable which works for me.

@t-tatoku Thanks but I need to create a custom link that only uses the ID as a query parameter.

Hi
Did you try to use a expression based on concat() function? You can add a fixed string (i.e. the URL part that is not dependant on ID) and then append the value of ID variable

 

First, you access to your Sharepoint List via web, make ID parameter visible on your view, and filter a random item by its ID

Flow_ID_basedLink.png

In my example the Sharepoint site is https://xxxxxxx.sharepoint.com/sites/yyyyyy/zzzzzz/ and the Sharepoint list is called PublicHolidays.

On my browser, I get the following URL structure:

https://xxxxxxx.sharepoint.com/sites/yyyyyy/zzzzzz/Lists/PublicHolidays/AllItems.aspx?FilterField1=I...

 

Then I verify I can remove the viewid part of the URL and access the resource directly from my browser by clicking:

https://xxxxxxx.sharepoint.com/sites/yyyyyy/zzzzzz/Lists/PublicHolidays/AllItems.aspx?FilterField1=I...

 

Assuming my flow stores the ID on a variable called 'ID', I just need to recreate it with the following expression:

concat('https://xxxxxxx.sharepoint.com/sites/yyyyyy/zzzzzz/Lists/PublicHolidays/AllItems.aspx?FilterField1=ID&FilterValue1=',variables('ID'),'&FilterType1=Counter')

 

You can replace variables('IS') and use whatever dynamic content you obtained from previous action blocks instead, as soon as it stores the ID of the item

 

Hope this workaround helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



The issue isn't the creation of the string but rather it not being recognized as HTML in the email.  See screenshot below.  I am able to create the URL string I need but I can't make it a clickable link within the email.Capture.PNG

Hi
Again
The following thread discusses this same topic, it's from 2Q2019. The workaround proposed is to discard 'html table' action card and build it from scratch
https://powerusers.microsoft.com/t5/Building-Flows/Manipulate-data-from-quot-Create-HTML-Table-quot-...

This second thread is a bit more promising, from 4q2019, also suggest a workaround and includes a link to vote for this functionality

https://powerusers.microsoft.com/t5/Building-Flows/How-to-format-link-properly-in-Create-HTML-table-...

Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Microsoft
Microsoft

@ramirezp 

I understand your problem. That is true, it is not recognized as HTML in the mail.

As efialttes mentioned, there are several discussions before. The following was easy for me to understand.
https://powerusers.microsoft.com/t5/Building-Flows/How-to-format-link-properly-in-Create-HTML-table-...

 

You might have already found the solution, but I made a similar flow.

FlowHtmlTable.png
Let me know if it helps!

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,495)