Unanswered

No function signature for the function with name 'startswith' matches the specified arguments error when filtering SQL data in combobox

(0) Share

Report

Posted on by MarcoSchade

Help me. I am getting the error:

"No function signature for the function with name 'startswith' matches the specified arguments. The function signatures considered are: startswith(Edm.String Nullable=true, Edm.String Nullable=true). inner exception: No function signature No function signature for the function with name 'startswith' matches the specified arguments. The function signatures considered are: startswith(Edm.String Nullable=true, Edm.String Nullable=true).

I am trying to set the filter on the Items property in power apps: Filter(INVENTTABLE;Len(ITEMID)=7 And StartsWith(ITEMGROUPID;"1000") And StartsWith(ITEMID;Dropdown1.SelectedText.FabrikNummer))

I can see that if i change this part "Dropdown1.SelectedText.FabrikNummer" to a set number og text, then it works fine.

The Dropdown1 has Items property "ShowColumns('[dbo].[Fabrikker]';"FabrikNavn";"ID";"FabrikNummer")"

If i put a label and makes it equal to Dropdown1.SelectedText.FabrikNummer i get the number i am looking for.

I am basically trying to filter a combobox based on a list imput.

How do i fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @MarcoSchade

The StartsWith function is designed to work with strings/text. If the data type of ITEMID is numeric, that would go some way to explaining this error.

If you want o filter by an exact value based on a dropdown selection, I'd suggest that you use the equality operator (=) rather than StartsWith.

Filter(INVENTTABLE; ITEMID = Dropdown1.SelectedText.FabrikNummer )

Was this reply helpful? Yes No
MarcoSchade 30 on at

Like (0)

Report

Hi @timl
But isn't the dropdown1 already formated as text, when i use "SelectedText"?
I can not use the equality operator since i am not looking for the exact value, but a value that starts with a certain value.
In the dropdown1 i am getting an ID for one of our factories. This ID is equal to the first three numbers in our productcode. I am trying to use the filter on the productcode to only show the product that are availble on a specific factory.

Was this reply helpful? Yes No
MarcoSchade 30 on at

Like (0)

Report
Hi @timl

I got it solved by placing a Text() around the
Dropdown1.SelectedText.FabrikNummer
So
Text(Dropdown1.SelectedText.FabrikNummer)

Was this reply helpful? Yes No