Answered

Conditional lookup Image hyperlink from sharepoint list wont appear.

(0) Share

Report

Posted on by Linmuel

Hello!

Newbie here. (Like 5 days old kinnda newbie) I'm trying to display an image from my sharepoint based on 2 dropdown criteria.
grp_drp = Row
stn_drp = Column

the whole area at right is the image control

I have my sharepoint list: I tried using both image and links (Images are in my sharepoint site document folder)

The Sharepoint Site accessibility setting is shared to everyone including, its files, and folders. So does the App

With hyperlinks, the app works on my end but when I share it with everyone else, the Images won't appear.

Here the code for the image control:

If(
 grp_drp.Selected.Value = "Bins",
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Bins,
 If(
 grp_drp.Selected.Value = "Tools",
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Tools,
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Equipment
 )
)

With Images, Only the first row images appears on both my end and other users and it takes a bit to load.
This is my code:

If(
 grp_drp.Selected.Value = "Bins",
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Bins2.Full,
 If(
 grp_drp.Selected.Value = "Tools",
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Tools2.Full,
 LookUp(
 '6S Image Gallery',
 Title = stn_drp.Selected.Value
 ).Equipment2.Full
 )
)

I am aware that my coding is as raw as fresh salmon but this is at the moment my current level of understanding with powerapps. I am looking forward to learning more.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Linmuel ,

There is nothing fundamentally wrong with your code - there are small condensing options, but will not alter the functionality. This may be a bug I have seen before referring to multiple image columns, however try this

With( { _Data: LookUp( '6S Image Gallery', Title = stn_drp.Selected.Value ) }, Switch( grp_drp.Selected.Value, "Bins", _Data.Bins2.Full, "Tools", _Data.Tools2.Full, _Data.Equipment2.Full ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Linmuel 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response! I'll try it once I get the chance!

Regarding with this "bug" have we identified what's causing it or is there a work around for it?

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Linmuel ,

I was mobile when I responded and could not test anything. The "bug" I was referring to was related to patching multiple Image columns which I have seen in a number of posts.

I have now tested both your code and my version and they both work here (as they should). I hope my version works for you. I noticed that you are running off two different drop-downs in the code - is this correct ?

Was this reply helpful? Yes No
Linmuel 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. 2 dropdowns. One for row and the other is for column. Like I said, I just started using PowerApps and I am basing my formulas from my excel experience. I'm really excited how things are working and I'd really want know more 🙂

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Linmuel ,

So does the code I provided work ?

Was this reply helpful? Yes No