Unanswered

Function Search has invalid arguments

(0) Share

Report

Posted on by elbi

Hi,

I am new to powerapps and cannot really understand what is going on. I have a default EditForm that is connected to a dataverse table Customers. The column WaitingLocation uses an option set list and this column is added to the EditForm.

I have changed the Items property of the dropbox to the following, because i want to display the current waiting customers for each location:

AddColumns(Choices(WaitingLocations);'Waiting customers';$"Waiting customers: {CountIf(Customers; CustomerState = [@CustomerState].Waiting And WaitingLocation = Value)}")

Everything works fine but when the SearchField property of the Combobox is set to "Value", the error "Function Search has invalid arguments" pops up. When I set it to "Waiting customers", the designer is happy.

Why is that? When i just use Choices(WaitingLocations) as Items, it also works.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @elbi ,
try this
AddColumns( Choices(WaitingLocations); "WaitingCustomers"; CountIf(Customers, CustomerState = [@CustomerState].Waiting And WaitingLocation = Value) )
elbi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @anandm08 ,
Then I get the error "table has not columns of type text".
Like I said: everything works with my code.
But I get this strange error and I assume thats some sort of bug in PowerApps. When using just Choices(WaitingLocations), I can use "Value" as SearchField with no error. When using AddColumns like above, the designer is mad at me.