cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JC75
Advocate IV
Advocate IV

Flow to send all list items as table including the actual Images

Hi, I have a list which contains 3 text columns and a Image column.

 

I want to be able to send all the list items in one email as a table that also shows the actual image.

 

So one emial would have Table with all entries in the list with Columns:  NAME, SURNAME, StaffNumber, Their Photo

 

I can do this for a table of just text values but how do I make it include the actual Image for each person embedded in the email also?

2 REPLIES 2
DamoBird365
Microsoft
Microsoft

Hi @JC75 

 

In order to add an image to the html table I used a replace function.  Standard html tag for an img is:

<img src="image address"> and so what I did was encapsulate the image address in two unique key strings that I could then replace with the start and end of the image tag.

 

DamoBird365_0-1615403496231.png

 

You could of course complete this in a compose but it's just as quick and easy to do it direct in the email.

 

@{replace(replace(body('Create_HTML_table'),'IMGSRCSTART','<img src="'),'IMGSRCEND','">')}

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Hi Damien

 

Sorry for the delay in getting back.

 

I can get this to work for the SharePoint Image column, its not a Picture/Hyperlink column but the New Image type.

 

Get Items from the list doesnt return any values for the Image column - so appears would need to use the Send an HTTP Request to the list and then some other steps to out put a table with the Text values and an Image. Any suggestions on how I query using the sendHttp and then take the values for each person in the list to present into a table?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,648)