The Function Search has some Invalid Arguments

(0) Share

Report

Posted on by Its-Maverick

Hi Everyone,

Im new to powerapps and trying to use the Search function. Im using a sharepoint list as the datasource.

However its throwing out an error. I'm attaching a screenshot. I'm pretty sure that the "FirstName" column is correct and part of the List as shown in the datatable. Can someone tell me what am i doing wrong here? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Its-Maverick

What kind of Column is Location in your list? Search will only work on Text columns.

Was this reply helpful? Yes No
Its-Maverick 14 on at

Like (0)

Report

Hi Randy,

The Firstname, lastname and location are text columns

Was this reply helpful? Yes No
Its-Maverick 14 on at

Like (0)

Report

Hi @RandyHayes ,
here is a sample data of the Table... As you can see, the Lastname and firstname and the location are text columns... Not sure why its throwing out an error

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Its-Maverick

Check the real name of the Location column...

To determine a column's real name, you can click on the column in the List Settings of your list and then in the address bar of your browser, look at the end of the URL - it will show the real name.

If that is different than Location, then use what you see in that URL.

Was this reply helpful? Yes No
Its-Maverick 14 on at

Like (1)

Report

Thanks @RandyHayes , I will check it tomorrow as I'm already on bed and about to rest. Thanks again

Was this reply helpful? Yes No
Its-Maverick 14 on at

Like (0)

Report

Hi @RandyHayes , I followed your suggestion and Hovered the mouse to the FirstName and LastName fields and looked at the details below of the browser.

It is showing field_1, field_2 and so on. I tried using the formula :
Search('Customers_GS_Sheet', TextInput1.Text, "field_1", "field_2")

and it is now filtering. Thanks for this! Much appreciated.

Is there a way to rename the field_1, field_2 to a more descriptive name?? like field_1 should be FirstName and field_2 should be Last name and so on. Thanks again!

Was this reply helpful? Yes No