Display Office 365 User Profile Picture

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I had a requirement in Power Apps to display Office 365 User Profile Picture.

I have a SharePoint list that has various columns like:

Employee ID = Title
Employee Name = Person or group
Employee Department = Choice

On my Power Apps screen, I need to display the employee details in a gallery control.

There, I need to display their profile picture, but some of the Office365 users don't have their profile picture; in that situation, I need to display their initials. How can I achieve this?

I tried with the code below, but it's not working. It's not even showing the other pictures.

If(
 IsBlank(Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email)),
 Concatenate(
 Left(ThisItem.'Employee Name'.DisplayName, 1),
 If(
 Len(ThisItem.'Employee Name'.DisplayName) > Find(" ", ThisItem.'Employee Name'.DisplayName),
 Left(Mid(ThisItem.'Employee Name'.DisplayName, Find(" ", ThisItem.'Employee Name'.DisplayName) + 1), 1)
 )
 ),
 Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email)
)

Can anyone please suggest how I can achieve this? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Please try:

IfError( Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email), "data&colon;image/svg+xml;utf8, "&EncodeUrl(" <svg xmlns='http://www.w3.org/2000/svg' width='100' height='100'> <text x='10' y='50' font-family='Arial' font-size='24' fill='black'>"&Concat(Split(ThisItem.'Employee Name'.DisplayName," ").Value,Left(Value,1)) &"</text></svg> "), Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email) )

Best Regards,

Bof

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
I am still facing the same issue. The user Serena doesn't have a profile picture; it is not displaying her initials.

Please help me out! Thank you in advance.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Maybe you could try:

If( IsBlank(Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email)), "data&colon;image/svg+xml;utf8, "&EncodeUrl(" <svg xmlns='http://www.w3.org/2000/svg' width='100' height='100'> <text x='10' y='50' font-family='Arial' font-size='24' fill='black'>"&Concat(Split(ThisItem.'Employee Name'.DisplayName," ").Value,Left(Value,1)) &"</text></svg> ")), Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email) )

This formula worked well on my side

Best Regards,

Bof

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft
It is not working for me?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Please try this formula instead:

If( !Office365Users.UserPhotoMetadata(ThisItem.'Employee Name'.Email).HasPhoto, "data&colon;image/svg+xml;utf8, "&EncodeUrl(" <svg xmlns='http://www.w3.org/2000/svg' width='100%' height='100%' viewBox='0 0 50 50'> <text y='50%' X='50%'>"&Concat(Split(ThisItem.'Employee Name'.DisplayName," ").Value,Left(Value,1)) &"</text> </svg> "), Office365Users.UserPhotoV2(ThisItem.'Employee Name'.Email) )

Best Regards,

Bof

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

I don't know why, its not working for me.

Was this reply helpful? Yes No