Answered

How to parse an image URL into a HTML table and display the image file?

Like (0) Share

Report

Posted on 3 Dec 2020 11:38:51 by Toby958

I'm working on solution in Power Automate to send a customised news digest from SharePoint Online. For this I am using a HTML table where the news article title, description, link and thumbnail are added to the table and then sent via email.

The solution works fine when populating textual data (strings), such as the article's title and description. However, it does not seem to work when trying to parse in an image URL. As you can see in the screenshot below, I've attempted to use the <img> tag to display the thumbnail, but the HTML table is displaying this as literal raw text.

2020-12-03 11_35_09-Window.png

Is there a way I can make the HTML table parse the image URL as an image?

Thanks!

All responses (35)

Answers (1)

mason007 31 on 05 Sep 2023 at 16:42:23

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

I noticed it only happens when selecting the Stock Images in SharePoint.
mason007 31 on 05 Sep 2023 at 14:59:45

Like (0)

Report
Re: How to parse an image URL into a HTML table and display the image file?

Hello,

I used Vlad1 for the Filepath expression:
substring(items('Apply_to_each')['Thumbnail'], indexOf(items('Apply_to_each')['Thumbnail'], '_layout')

That was working until I selected an image from Outlook web images in our tenant, then I got this error on my flow:
Unable to process template language expressions in action 'Filepath' inputs at line '0' and column '0': 'The template language function 'substring' parameter is out of range: 'start index' must be non-negative integer and should be less than the length of the string. Please see https://aka.ms/logicexpressions#substring for usage details.'.

The first expression didn't work, giving me a access denied error:

join(skip(split(items('Apply_to_each')['Thumbnail'], '/'), 3), '/')

Any help you can provide is appreciated!
SJNBham 51 on 21 Jul 2022 at 16:21:34

Like (1)

Report

Re: How to parse an image URL into a HTML table and display the image file?

Hi @Anonymous - here's how we build the articles portion of our email. We use a variable to store the Link to Item value because we populate that with an alternate link if it's a repost news item.
Community Power Pla... on 19 Jul 2022 at 09:15:59

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

No it's not sensitive... it's just the test...
here is the HTML for the link that is not working
and here is the link to my working example
Paulie78 8,416 Moderator on 19 Jul 2022 at 08:47:39

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

Show an example of the final HTML that is produced. If you view the source of the email in outlook does the content and HTML look correct?

You can PM it to me if it is sensitive.
Community Power Pla... on 19 Jul 2022 at 08:45:30

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

I tried that as well but not working
Paulie78 8,416 Moderator on 19 Jul 2022 at 08:43:43

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

You do not have double quotes around the link. Your example would produce:

<a href=https://....><p>....

But you need

<a href="https://..."><p>...
Community Power Pla... on 19 Jul 2022 at 08:35:08

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

hi @Paulie78! thanks for your reply.. yes it is not taking the <a href =" " >text</a> in the URL... all my work is complete except this one... this is how I am passing my Link in the code
and this is how I am setting my Select action

is there anything I can add to get it resolved... your help would be highly appreciated
Paulie78 8,416 Moderator on 19 Jul 2022 at 08:28:05

Like (1)

Report

Re: How to parse an image URL into a HTML table and display the image file?

I don't think I understand the problem. The link in your screenshot looks ok, so is it changing before it gets delivered in the email?
Community Power Pla... on 19 Jul 2022 at 07:55:29

Like (0)

Report

Re: How to parse an image URL into a HTML table and display the image file?

hi @Paulie78 thanks for your help... the method helps me to resolve the image-related issue but now m facing a new problem... the 'Link to item' is not working, when I see the output of my select it's showing me the exact link to the post but appending to string variable is not adopting this...

any help would be great!... I commented on your video as well but did not get any reply 😞