Updating a Custom List with the Office365 profile picture to display photo

(0) Share

Report

Posted on by Pedrogr90

Hello

Current I have a flow that retrieves the user photo from O365 like this:

My problem is that I don't know how to use the output (the binary) to update a column in a custom List that I have in order to display the photo as a thumbnail. The List just contains basic employee data like name, email, etc.

As far as I read online, the column called for example "Photo" must be of type "Hyperlink". However, that's just text.

Can someone point me in the right direction?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@Pedrogr90 are you looking to save link to user's profile picture in SharePoint list? If yes then you can save the below URL in the picture column, replace <useremail> with user's email address.

<siteurl>/_layouts/15/userphoto.aspx?size=L&username=<useremail>

Was this reply helpful? Yes No
Pedrogr90 27 on at

Like (0)

Report

Hello

What I am trying to achieve is to display the user photo in the SharePoint column. Its true that the above URL gets the user photo, but my main problem is how to display it on the SP list column

Thanks

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Pedrogr90 so i understand you want to display user photo in SharePoint column, please note that SharePoint column type should be Hyperlink or Picture as shown in screenshot below

Now do you want to set the value of the column from a flow? is there any specific reason why you want to set the picture value in column from flow?

Was this reply helpful? Yes No
Pedrogr90 27 on at

Like (0)

Report

Okay so now I know that its Hyperlink or Picture with Picture option in Format URL. I would need to find out how to do that via a HTTP request to Sharepoint because I want to automate the process. The reason behind why I need this is because the List contains employee info, and I would like to add the photo of each employee.

Now also the question is, how can I use the output from Get user photo V2 to include it in the column?

Thank you

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Pedrogr90 so first, how you want the flow to trigger, it on edit of the item, or you want the flow to periodically get the items from list and update the pictures in those items?

You can update the picture column value using http request to SharePoint from flow as shown in below screenshot

Was this reply helpful? Yes No
Pedrogr90 27 on at

Like (0)

Report

Okay and back to the original question. How do I handle the output of get user photo v2 to include it in the HTTP request?

Thanks

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@Pedrogr90 you dont need to get user photo, use flow expressions in compose action, in this expression, replace https://domain.sharepoint.com with your site URL. Replace Author with your column name from which you want to get the user email

concat('https://domain.sharepoint.com','/_layouts/15/userphoto.aspx?size=L&username=',outputs('Get_item')?['body/Author/Email'])

Then use the output of compose action in the Send HTTP action body parameter

Was this reply helpful? Yes No