Unanswered

Get image from Sharepoint list or library, and show the picture base on a dropdown selection

(0) Share

Report

Posted on by OliverV

Hi All,

My application is an asset usage application. I have created a sharepoint list containing the assets, and in the power app a dropdown having the "Items"= Itemlist.Title. (dropdown in the image)

What i would like to achieve is to have above the dropdown 1 picture element, which based on what i select in the dropdown, shows that item image. (golden square in the image)

I don't know which is the good approach for this:

1) store the images as attachment in the "itemslist"

2) store the images in a sharepoint Library, naming each picture as the Items in the Itemlist.

Can i achieve this with simply powerapp or should i use also Power automate?

Thank you in advance for the help!!!!

@WarrenBelz?? 🙂

Categories:

Building Power Apps

Annotation 2020-0...

I have the same question (0)

All responses (24)

Answers (2)

Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (5)

Report
Hi @OliverV ,
This one is quite straight forward. (use your names for the Blue bits).
Create a SharePoint Library ImgLibrary and file the pictures in.
Include in the fields of the Library two items
A field called Thumbnail formatted as Hyperlink or Picture > Picture
A text field containing the reference you will be selecting - I will call it Title as per your mail
In the app DropDown ddTitle, I will assume ddTitle.Value is the resulting reference.
So all you need is an Image Control with the Image property
LookUp( ImgLibrary, Title = ddTitle.Value, 'Thumbnail ({Thumbnail})'.Large )
The picture should change each time you select another item.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
OliverV 69 on at

Like (0)

Report

@WarrenBelzyou're awesome, if by chance u come around Budapest, u're my guest for a coffe/beer 😄

With library is 100% working.

only a last small question. This same solution is it possible with Sharepointlist attachments?

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

Hi @OliverV ,
Technically maybe, but a lot more effort and not something I have bothered with.
You live in a beautiful city - attached is a photo I took in July 2019. I live in Queensland Australia.

BudapestChurch.JPG

Was this reply helpful? Yes No
faisalrahman 9 on at

Like (2)

Report

You can use simple First() function to retrieve image from your SharePoint list into a gallery In the Gallery bring an image control and write following code in the image control:

First(ThisItem.Attachments).Value

Was this reply helpful? Yes No
Senvanquy 2 on at

Like (0)

Report

Another solution : you can convert image to base64 type . At the sharepoint list column, you must set column is mullti line text and pate code image base64 to there. Well done

Was this reply helpful? Yes No
Eva1 16 on at

Like (0)

Report

Thank you! THIS was the code I needed to be able see the pictures from the image column in the sharepoint list in my powerapps gallery, thumbnails!

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (2)

Report

Hi @Eva1 ,

I have done a blog on various options of storing and viewing photos - it may be useful to you,

Was this reply helpful? Yes No
mthaker 50 on at

Like (0)

Report

Thank you Sir !
It's working 😊👍

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello Warren,
I'm facing kind of similar issue. I've uploaded the needed images to the documents to have an image library, except that I did not choose the column to be Image\Picture, it got named as "Name" by default. (Screenshot attached)
I want each choice in the dropdown list to have different image.
& used the following code:
Image= LookUp(Documents, Part = DataCardValue27.SelectedText.Value,Name)

Please support.
Many Thanks,

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (2)

Report
@Anonymous ,

This is an old closed post, but to answer your question, Name is the name of the file you put in the Library. The reference you need is probably

LookUp( Documents, Part = DataCardValue27.Selected.Value ).'{Thumbnail}'.Large

This is all in the blog I referenced.

Was this reply helpful? Yes No