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?
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
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:
Then I verify I can remove the viewid part of the URL and access the resource directly from my browser by clicking:
Assuming my flow stores the ID on a variable called 'ID', I just need to recreate it with the following expression:
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
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.
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.
You might have already found the solution, but I made a similar flow.
Let me know if it helps!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!