Struggling to get user image from a distinct list of users.

(0) Share

Report

Posted on by Alex_Security

174

Hi All,

bit of a niche one, but i'm struggling to get an image of a specific user that changes dynamically with time, as i only have the users full name as a "ThisItem.Result" tag. i've tried searching a user in another gallery and getting the profile, but i then can't return that to the same gallery as the one the result is found in. i've tried first, converting thisitem.result to text, and everything else i can think of. the database the name is pulled from does not have the users email so i'd need a dynamic way to search this.

thanks,

Alex.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Alex_Security

You could use the name and get the information from the Office 365 Users connector.

However, is this SharePoint? If so, then you already have the information in the list if you are using a Person column.

Also, what purpose does the Distinct play? Keeping in mind that Distinct will only return a distinct table of a single column...sounds like you need more than just a single column.

Please expand more based on the above.
Alex_Security 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,

how would i use the name within the same gallery? i've tried using Office365Users.UserProfile(Office365Users.Search({searchterm:Thisitem.Name,top:1})).Mail but that doesn't work, i've removed the distinct, but even with the text name as a thisitem.text, i can't seem to get the user email as a label in the same gallery. my best guess is the below is due to the search returning a table as opposed to a text value?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Alex_Security

Is this SharePoint? Do you have a person column in use in your list?

You are mention about getting the Mail of the user - but your original post was about the photo. What is it that you are trying to achieve?
Alex_Security 174 on at

Like
a
(0)

Report
Copy link

Link copied!

it's a sharepoint list, wherein the name column is a single line of text. not the best structure, but not one of my creation sadly.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Alex_Security

Okay, but are you trying to get a photo or an email?
Alex_Security 174 on at

Like
a
(0)

Report
Copy link

Link copied!

so my thinking is, i need the email, from which to then get the photo. unless there is a route to directly get the photo using just the user name?
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Alex_Security

Yes, you will need more than the name - email is a logical place to start.

This formula should provide your photo based on the name:

With({_usr: First(Office365Users.SearchUserV2({searchTerm:ThisItem.Name, top:1}).value)}, If(Office365Users.UserPhotoMetadata(_usr.UserPrincipalName).HasPhoto, Office365Users.UserPhotoV2(_usr.UserPrincipalName), SampleImage ) )
Alex_Security 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

so this code is working, but when the app loads in live i get the following error:

I believe its because not all users have an image in AD, and i've even tried wrapping the whole with statement in an IFERROR(<formula>,"") but to no avail. is there any way of removing this error?

thanks,

Alex