Hi All,
I have created a collection of my dataset which is a SharePoint list.
In my app, Gallery, I am trying to filter the collection with a combo control (choices of Phases) and a search text input by using the below formula : Search(Filter(colGridData,Phases = cmbfilterphases_1.Selected.Result),TextInput_search_project_2.Text,"Project_Name").
Here colgriddata is my collection of SharepointlIst and Phases is the choice field and TextInput_search_project_2 is my text input field to search the gallery for the project name.
However I am getting an error Incompatible types for comparison. These types can't be compared Record , Record.
Can you please assist.