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.
So when I click the arrow on the gallery to show a display form it has no values and only returns the column names
I saw to use the following syntax with Lookup() cause you cannot use gallery1.selected since it has a filter
LookUp(Table2, ID = Gallery1.Selected.ID)
But this does not work. I dont know why, I think its cause I dont have a lookup column since my data source is an excel?
I just want to be able to display the data on the form for whatever record I select from the gallery.
Thanks in advanced!