You’re offline. This is a read only version of the page.
Announcements
This problem is specific for Powerapps for Teams.
I am having some trouble with filtering my gallery view, based on two input; a text search and a drop down menu.
This is the code I am using in the Items property of the gallery:
Share
ReportSort(
Filter(
Prøvegjennomgang_lab, //my data source
Lokalitet.Value = varProsjekt, //this is an attribute that is filtered before entering the screen with the gallery, it works just fine
StartsWith(IntrasisID, 'Søk prøver'.Value), //this is the text search, works just fine
IsBlank(PrøvetypeFilter.Selected) || Prøvetype.Value = PrøvetypeFilter.Selected // this is the problem, where Prøvetype is a Choice column, and the PrøvetypeFilter is a dropdown menu
),
IntrasisID,
SortOrder.Ascending
)
I keep getting the error "Incompatible types for comparison" in Prøvetype.Value = PrøvetypeFilter.Selected, but there is no option to add .Value to Selected, only SelectedItems, which also throws the same error.
Is there something I am missing completely?
So it turned out I had missed something completely. The choices in PrøvetypeFilter came from a collection. I had the Item property for the filter set to nameofcollection.Result rather than .Value. After changing it I could use .Selected.Value in my filter.
All responses (
Answers (
711
