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 (30)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(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
a
(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
a
(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,909 Super User 2026 Season 1 on at

Like
a
(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
a
(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
a
(0)

Report
Copy link

Link copied!

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

Like
a
(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
a
(0)

Report
Copy link

Link copied!

Like this ?

Was this reply helpful? Yes No
Miik 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Also, here is the DataCard:

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

Like
a
(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