cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SylvieLet17
Responsive Resident
Responsive Resident

Add Office 365 Profile Image to HTML Table?

Hi all, 

I have a list in Sharepoint, and a flow that is scheduled and Gets Items (with an ODATA query)

then it pops these items into an HTML table via "create HTML table" action. 

One of the columns in the list is an image URL - which points to the O365 UserPhoto and it looks something like this:

 

https://mydomain.com/sites/my-tool-site/layouts/15/UserPhoto.aspx?Size=L&AccountName=My.User@myDomain.com 

 

I can use this in Power Apps to create a nice HTML table, and I know how to make the link appear as an img in the app, but now I want to use Flow to put the image in a cell in an HTML table, then send it via email. 

Anyone done this? Is it possible?

 

Thanks!

3 REPLIES 3
Mira_Ghaly
Dual Super User II
Dual Super User II

Hi @SylvieLet17 

Have you tried to use custom header and value on the createHTMLTable Action and set the value to something like this

concat('<img src=',yourURL,'></>') and set it to the value

Mira_Ghaly_0-1599738542759.png

'

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
sudharsan1985
Super User
Super User

Hi @SylvieLet17 

I tried the scenario of embedding the URL in the email, the picture is displayed only in the web and the user is already authenticated to the site, in case the mail is configured in outlook client, I don't think so the image will be displayed. The only option is to get the file content as base64 and for that, I think you have to use the HTTP premium action to get the file content using the URL, or maybe you can use a document library full of profile photos and then use that library to send the image in the email.

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...
Paulie78
Super User III
Super User III

@SylvieLet17 there is a solution for this which does not require premium. Would you like me to post details or have you sorted it out now?

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (23,474)