Getting specific image from Sharepoint

(0) Share

Report

Posted on by IceBerg

Hello Everyone!

I am trying load an specific image from sharepoint.

It's structure is like this:

The name of the file is the same info I get on :

First(EmployeeProfile).MailNickname + ".png".

But I don't know exactly how to load the image on Powerapps.

Could anyone please help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @IceBerg

You can do the following, i assume you only have 1 attachment as the file in that list.

add an image control and set Image = First(LookUp(EmployeeProfile,Name = "imagename.png").Attachments).Value

If you are doing it dynamically remember its yourVariable & ".png" (yourVariable.png) not +

Hope this helps

Was this reply helpful? Yes No
IceBerg 24 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer but it did not work.

The thing is, each image's name = First(EmployeeProfile).MailNickname & ".png"

On this print screen, I guess it gets clearer :

Each file represents one user and I want to get the current user's image.

Btw, to avoid any misunderstanding (I'm not looking for the current users profile picture nor anything like that, i just need to get the image from this sharepoint or have an Idea of how to get specific image for each users from sharepoint)

I was wondering how to get it from the sharepoint

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hi @IceBerg

Consider the following:

A SharePoint List called 'Some Request Form' with columns Title, Motivation, ...

You have two rows in this list, request 1 and request 2 and an image attached to both of them

The Power App is connected to this list

There is a gallery galRequests with its Items = 'Some Request Form'

There is an image control on the form and its Image = First(galRequests.Selected.Attachments).Value

Another image control and set its Image = First(LookUp('Some Request Form',Title = "request 1").Attachments).Value

Result

in the first image you retrieve the first image in the attachments table for that row

in the second image you specify the Title (usually you will go for the ID of the row to ensure its unique) of the row which image you wish to see.

I trust this is more clearer?

R

Was this reply helpful? Yes No
IceBerg 24 on at

Like (0)

Report
Copy link

Link copied!

I guess I understood what you said, but in your example, you have an additional column named "title", I don't have it, I only have the file name. I guess I will have to figure out how to add a column, copy the file's name in to it and them use the formula. (I have more than 6k images in this folder, one for each user)

Was this reply helpful? Yes No