Comparing Collection Text to Table Values for Images

(0) Share

Report

Posted on by samdean332

Hello,

I have a table that contains images paths.

I want to compare the titles to items in a collection, and if they match, display that image for the given technology. So, I have tried:

It keeps complaining that it expects an image value, but even when I trying a manually uploaded media, I get the same error:

How can I dynamically comparing Technology.Titles to an image table to display the corresponding image? Or, how would this potentially work with manually uploaded images?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@samdean332

You cannot set properties of controls in PowerApps with an equal operator.

Your formula must return the Value that you want for the Property you are using. So in your case, the Image property formula should be:

If(ThisItem.Technology in Icons.Title, ThisItem.'Icon Path')

However, you have not given context of where this is in your app. It appears to be in a Gallery since you are referencing ThisItem.

So, without knowing that detail, the above formula is a general formula for what you need.

I hope this is helpful for you.

Was this reply helpful? Yes No
samdean332 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the info. To provide more info, ThisItem.Technology contained in a Gallery/Collection created earlier in the App. However, Icons is a static Excel table uploaded to the app, so I cannot use a ThisItem.'Icon Path' to reference that particular row - or at least, I do not know how to do that. Basically, I just want to take my collection compare to the rows in the Icons table and retrieve the corresponding images. It would be displayed in this gallery:

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@samdean332 What is the Items property for your Gallery? Is it the Collection that contains the data loaded from the Excel file or is it referring to something else? If so, what the data in this Collection? Please provide more details.

Was this reply helpful? Yes No