I want to implement a function that takes a user’s input from a search box and cross-references it with the ‘name’ field in the products database. If a match is found, the layout of the repeating group display will be updated. The product matching the user’s input should be positioned at the top of the list in the repeating group.
I know one solution was posted already, but just going to add what I consider the best solution.
Use the search box element as I believe you are from original post. Data type is Product, field to search is name.
In RG that has content type of Product put a conditional for when search box value is not empty and property to change is data source. The data source will be searcbox value converted to list.