Announcements
Good day everyone,
I'm building an app and need to validate if a specific text is in collection column.
Example: Check if "Photo" text exists in Collection.Column.
Result: Photo - Sky.PNG
Something like that. can somebody help me?
Regards,
hi @Davidx23 you can accomplish this with the Filter function
Add the following to your canvas
With the Gallery set Items = Filter(yourCollection, YouColumn = textInput.Text)
With the label in your gallery, set the Text = ThisItem.yourColumn
Hope it helps,
R
Rubin,
No, the target is to validate if a document was uploaded by looking for its tag which is always at the beginning of its name as i mentioned in my previous post. So i need to validate that a Photo document was uploaded before save the data. to get this im trying to validate if the text "PHOTO" exists in the collection of my attachments file in order to proceed.
Any other option to get it, will be welcome
🙂 ok got it
With the Gallery set Items = Filter(yourCollection, StartsWith( yourColumn,"Photo")
This will return a gallery with all the items rows that does have the text Photo in the beginning.
Or you can add a column to a collection. ClearCollect(newCollection,AddColumns(yourCollection,"Text Exists", Left(Column, 5) = "Photo"))
Now you can check that column if true it exists if false it doesnt.
Hope this helps
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
