Search on Powerapps

(1) Share

Report

Posted on by Community Power Pla...

I am a Newbie to Power Apps.

I am building a simple Power Apps on MS Team and share with my Team Group.

I use the default Dataverse as my database with 6 columns

After the Canvas apps is built, I can input data, but I cannot search.

Here more information:

Table Name: TIP

Some column Names: TIP, App, Rep

Search Box Name: textInputSearch

My syntax: Search(TIPS,textInputSearch.Text,"App")

It returns "The function 'Search' has some invalid arguments"

Please advise.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

Is "App" a text / string column if not that is an issue as the Search function searches string. If it is returning blank values despite this try this:

If(IsBlank(textInputSearch.Text),TIPS,Search(TIPS,textInputSearch.Text,"App"))

My first thought is that the column is incorrect e.g. not text update me as to whether that is the case If so what type of column is it? also the search function sometimes formats the column it is searching by (this bit in red: Search(TIPS,textInputSearch.Text,"App")) as not the display name so double check that it is correctly formatted.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for your reply.

All columns are text. Thus, I cannot figure out why it says there is wrong argument

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report
Hi @hoaddy ,

You would need to provide the schema name of the App column. See below I have used emailaadress1 schema name for Email column in search function.
Search(Contacts,TextInput2.Text,"emailaddress1")

Schema name format -> publishername_columnname

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Here is the sample table:

In the gallery view, you can see the error message:

But if I change it back to "TIPS", it shows the information.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

Hi @hoaddy ,

It is never recommended to use system default names as data table column names. As you can see, there is an App "control" under the add screen button in that tree view. It provides information about the currently running app and control over the app's behavior. You could refer to below doc:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/object-app

So from your end, please try and modify the column name, "Apps" is enough for you to use.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No