Hi,
Need assistance with filtering a gallery using multiple criteria with a DataSource in SharePoint
The data source has 3 columns namely:
1. Project Code (Text)
2. Project Year (Text)
3. Project Quarter (Choice)(4 Choices Given)
In order to filter the data in the gallery I created 2 text boxes and a dropdown for the user complete in order to get a result in the gallery. The two text boxes gives a result when data is entered into them. The challenge is the drop down box to select the Project Quarter and get a result.
The items property of the galley is as below:
Filter('Monitoring Tool Database Key',Title=Project_code_registration.Text,'Project Year (MTK)'=Performance_Year_Registration.Text,'Project Quarter (MTK)'=Dropdown1.SelectedText)
I have used variations of this formular where the choices of the drop down came from the data source and not from a separate list but this does not seem to work in this scenario.
When running the formular the error I receive is: "Incompatible types for comparison. These types cant be compared. Record,Record"
Any assistance in this regard will be highly appreciated
