So I have a gallery that has the following filter so it can be used with search bar
Filter(AddColumns(Table2, "ColumnName",'Column Name'),
StartsWith(ColumnName, SearchbBox.Text)
)
I added a column because the filter does not work with column names with spaces in it.
I changed the OnSelect property of the arrow to the following below:
Select(Parent) ; Set(varColSelecred, ThisItem.col)
And the Items property of the form to
LookUp(Table2, varColSelected = Gallery1.Selected.col)
This solution on displays the first record of the excel file, even when clicking other records in the gallery. I did it this way because setting the forms' item property to Gallery1.Selected Did not work. I have been stuck on this for the past 2 weeks.
I need a solution to be able to display a form from a selection from a filtered galllery.
Please Help!

Report
All responses (
Answers (