Hi, I am trying to filter this gallery by a jobnumber, e.g. go into a jobnumber and the gallery only shows entries that match that jobnumber. The jobnumber field in the gallery is ThisItem.Title and i have a label on the screen Label179 that displays the jobnumber. Need the gallery to filter (ThisItem.Title)=label179.Text (ThisItem.Title is the jobnumber in the gallery and Label179 is the jobnumber it needs to be filtered by)
I currently have the gallery filtered where they can select the jobnumber from the search but would the like to have it default before any selections to show only the jobnumber relevent to the screen they are on. Just need to get this at the beginning of the syntax - (ThisItem.Title)=label179.Text
Search(Filter(ExternalCollect,Len(Dropdown5.Selected.Value)=0 || ListType.Value=Dropdown5.Selected.Value),
TextInput4.Text, "Title","Part_Name")
I am using a sharepoint list as the datasource. Any assistance would be much appreciated