Getting the initials from a people's columns

(0) Share

Report

Posted on by Sajarac

3,271

Hi there.

I hope someone could point me in the right direction here:

I have a people column in my sharepoint list. and I am displaying in my gallery the person picture. with an image like this:

ThisItem.Project_Manager.Picture.

But Some of my users doesn't have a picture. I juts see something like this:

I want to show a label only if the Project MAnager has been selected and if the Project Manager Doesn't have a picture.

Thanks in advanc for any response.

BTW the label that I want to show is the Project Manager initials but that part I've got it working. Thx

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

SebS 4,582 Moderator on at

Like (1)

Report
@sajarac

You can try like this :

Label visible:

If( Not(IsBlank(ThisItem.Project_Manager)) && IsBlank(ThisItem.Project_Manager.Picture), true, false )

Now label :

Left(ThisItem.Project_Manager.DisplayName, 1) & Mid(ThisItem.Project_Manager.DisplayName, Find(" ", ThisItem.Project_Manager.DisplayName) + 1, 1)

There is also another option to use Split and First if you have First Name and Surname field in User Profile

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Hey @SebS , thank you very much for your prompt response. I have applied your formula. But I can not see the label after implemented.

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report

@sajarac

The formula checks if the Project manager is not blank and the Picture is blank.

You can, for now, place true to see the label. I'm unsure if no image is shown as default, which will mess with that formula.

I will need to check in test App I do not remember from top of my head 🙂

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

No worries. Take your time. I guess the blank picture is taking as a result that in fact the user has a Photo.
I will wait for your test.
Thanks in advance

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
@sajarac

Yes, DefaultImage is used, so it's tricky to do the verification. You can try the below code in the Visible property:

!IsBlank(ThisItem.Project_Manager.Email) && Office365Users.UserPhotoMetadata(ThisItem.Project_Manager.Email).HasPhoto

The code for initials is working ok

now there is a blog about how to achieve this as well so have a look into this :

https://www.matthewdevaney.com/power-apps-display-a-user-photo-or-initials/

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

This is the result fotr the latest formula:

As you can see the user with photo is showing also the label with the initials.

Was this reply helpful? Yes No
Verified answer

SebS 4,582 Moderator on at

Like (1)

Report
@sajarac

Try only use :

!(Office365Users.UserPhotoMetadata(ThisItem.Project_Manager.Email).HasPhoto)

This shows a boolean when a photo is there so use ! to say if the Picture is Not there, show true

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Awesome! 😀
That one works !
Thank you very much for your help! 👍👍👍👍👍

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report

@sajarac

No Problem 🙂

Was this reply helpful? Yes No