Answered

Thumbnail and lookup problem. The image doesn't appear.

(0) Share

Report

Posted on by Marna2022

Hi!
A few months ago my App was working without issues, I uploaded and change a table each time. No problem.
Starting this year I did a change. Now, I cannot see the images, pictures that are associated to a question.

My App is a "TEST" App, where I have a table with questions, possible answers and correct answer.
Sometimes the question is "which is the name of this product?" and a picture of a product appears.
- The question's table is in EXCEL
- The images are in SharePoint

In Sharepoint all the images have the ID column.
In Excel I added an "ID_image" column where I use the sharepoint ID that I need.
So, I connect them.

Now, separately, it works!

I can see the image if I do this:

LookUp(Documents,ID=53). Thumbnail.Large

I can see the correct ID number if I do this:
LookUp(Questions,QID=varNum,'ID_Product ')
The answer to this formula is 53

However, If I match them on an image icon:
LookUp(Documents,ID=LookUp(Questions,QID=varNum,'ID_Product ')). Thumbnail.Large
This doesn't work!

Any idea why?
I get the yellow triangle saying that "incompatible types for comparison".

It should easy to solve, it worked before, but it isn't working now.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Marna2022,

A couple of things here - Excel is a terrible data source and will cause you more grief than this, particularly as the data gets bigger. If you have access to SharePoint Lists, you might consider moving the Excel data there.

However back to your issue - are both the 'Product ID ' and QID fields in Excel number fields ? I have added a Value() conversion below on the second one if that is the issue. You are also going to have Delegation issue with your current code - try this for a start
With( { _ProdID: LookUp( Questions, QID = varNum ).'ID_Product ' }, LookUp( Documents, ID = Value(_ProdID) ).'{Thumbnail}'.Large )

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
Marna2022 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!!!!

It worked perfectly.

Yes, I know I have to change to Sharepoint!

I started with Excel because I now how to work with, but after this project, indeed using other sources is probably the best.

Thank you very much!

Was this reply helpful? Yes No