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!