Finding a Value in a Collection / Gallery

(0) Share

Report

Posted on by Hack-7

216 Super User 2025 Season 1

I have been trying to figure out how to find if an item in a collection or gallery can be compared to a textbox. This would then set a variable for me to use later.

Basically, I a building a collection (colCurrentProjects) for projects. In this collection there is a column called projectID. The collection gets displayed in a gallery (galProjects).

So how would use an If() allItems in the collection or gallery projectID = SpecificProjectID" and return a true, false?

Cheers

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

DownForce 152 on at

Like (0)

Report
Re: Finding a Value in a Collection / Gallery

Use the in operator.

If(projectID in Gallery1.AllItems.SpecificProjectID, true, false)