Hi all,
I "inherited" an app from a former coworker, and need some help in adding a search function. The app is a collection of all apps that the end users has access to, and we pin this in teams so that everyone across the organization has easy and quick access to whatever apps they need. My issue is that the "displayName" for each app (I.E: the name of the app) is stored in a table within a column titled "properties" in the collection. I don't know if it is possible to search this, but I've had no luck so far. The app currently will let a user search apps by "id" or "name", but both are long strings of numbers that the users will never know. I'll include code and images below:



The search works, but you can't type the name of any apps and get results. you have to type what is in the "name" category. I know my formula is referencing "name" but I don't know how to make it reference anything outside of these few columns.
If anyone knows how I could search this, or an easier way to do this, I would greatly appreciate it!