Dear community,
I am currently trying to filter a gallery based on 4 different Dataverse columns
In general I still am not able to figure out how to filter this Gallery based on Whole Number Columns.
My filters are working fine with the other Lookup-Column and the Choice-Column
In my example the columns Losnummer and Laufende Nummer are of the datawype whole number.
When I try to convert the values with Value to a number, Power Apps does expect Text, but when I put a Text around the formula, Power Apps shows the error message No function signature for the function...
//Messwerteprotokolls
If(!(IsBlank(arbeitsgang_drpdwn.Selected.Value)),
SortByColumns(
Filter(
Messwerteprotokolls,
StartsWith(Sachnummer.Teilenummer,bauteilsearch_txtbx.Value)&&
Value(losnummersearch_txtbx.Value) in Losnummer &&
Arbeitsgang = arbeitsgang_drpdwn.Selected.Value
&&
Value(lfdnummersearch_txtbx.Value) in 'Laufende Nummer'
),
"fbmp_losnummer",SortOrder.Ascending,
"fbmp_arbeitsgang",SortOrder.Descending
),
SortByColumns(
Filter(
Messwerteprotokolls,
StartsWith(Sachnummer.Teilenummer,bauteilsearch_txtbx.Value)&&
Value(losnummersearch_txtbx.Value) in Losnummer &&
Value(lfdnummersearch_txtbx.Value) in 'Laufende Nummer'
),
"fbmp_losnummer",SortOrder.Ascending,
"fbmp_arbeitsgang",SortOrder.Descending
)
)
Thank you in advance for your help!
It seems to be that I need to use another function than Filter in or StartsWith for Whole Number Columns (Dataverse)
Kind regards
