Answered

Search in PowerApps Form

(0) Share

Report

Posted on by Miik

Hi,

I have added a Search textInput box to my form. I called it tbSearch and the form is called SharePointForm1, my source data is 'GP Site Details'. When I select the form, I use Item and place the code in the function box.

I want to search by Practice Name, but the code I use does not work:

Filter('GP Site Details', StartsWith('Practice Name', tbSearch.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (29)

Answers (1)

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Try this:

Filter('GP Site Details', tbSearch.Text in 'Practice Name')

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
cdwhite 1,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Miik ,

Is it filter or search you want to do? The syntax is slightly different if using search, it would be something like:

Search('GP Site Details', tbSearch.Text, "Practice Name")

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for helping. I tried, but I got a warning

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Miik

What is the error the "in" is giving?

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for getting back to me on this issue.
I got a warning:

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you also put a screenshot of the data source?

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report
Copy link

Link copied!

Like this ?

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report
Copy link

Link copied!

Also, here is the DataCard:

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Did this worked?
Search('GP Site Details', tbSearch.Text, "Practice Name")

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No