Search in PowerApps Form

Like (0) Share

Report

Posted on 30 Aug 2023 15:14:55 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:

General Questions

All responses (29)

Answers (1)

Miik 94 on 04 Sep 2023 at 07:44:05

Like (0)

Report

Re: Search in PowerApps Form

Thanks for your help on this, all great and appreciate your help on this issue.
SpongYe 5,580 Super User 2025 Season 1 on 02 Sep 2023 at 09:17:10

Like (0)

Report

Re: Search in PowerApps Form

@Miik
Please let me know if this helped.

------------------------------------------------------------------------------------------------------------------------------
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.
Verified answer

SpongYe 5,580 Super User 2025 Season 1 on 01 Sep 2023 at 12:20:13

Like (0)

Report
Re: Search in PowerApps Form

Hi @Miik

Nice, it worked!
We need to avoid the use of IN when searching in dataset that why the warning about large datasets:
LookUp( 'GP Site Details', 'Practice Name' = tbFilter.Text )

If it worked you will be able to see the record that you searched for.
Add a label in your gallery:
ThisItem.'Practice Name'

Watch this video to learn how to use Filter, Search and LookUp functions.
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

------------------------------------------------------------------------------------------------------------------------------
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.
Miik 94 on 01 Sep 2023 at 11:37:38

Like (0)

Report

Re: Search in PowerApps Form

Forgot to say, although these worked:
Filter('GP Site Details', tbFilter.Text in 'Practice Name')
Filter('GP Site Details', StartsWith('Practice Name', tbSearch.Text))
I do get a warning about large datasets.
Miik 94 on 01 Sep 2023 at 11:36:51

Like (0)

Report

Re: Search in PowerApps Form

Hi,
I added some text input fields to the gallery as I thought hmm, if its working, how would the data appear. Sorted, but with a Gallery and Form, what do I do now ?
I can use both can I ?
These worked in my gallery:
Filter('GP Site Details', tbFilter.Text in 'Practice Name')
Filter('GP Site Details', StartsWith('Practice Name', tbSearch.Text))

These Didn't
Search('GP Site Details', tbSearch.Text, "Practice Name")
Filter('GP Site Details', tbFilter.Text='Practice_x0020_Name')
Miik 94 on 01 Sep 2023 at 09:40:43

Like (0)

Report
Re: Search in PowerApps Form

Search('GP Site Details', tbSearch.Text, "Practice Name")
Filter('GP Site Details', StartsWith('Practice Name', tbSearch.Text))
Filter('GP Site Details', tbSearch.Text='Practice_x0020_Name')
Filter('GP Site Details', tbSearch.Text in 'Practice Name')

I tried all these and no luck. Maybe I am no 100% on Gallery, but this is what I did:
Miik 94 on 01 Sep 2023 at 09:00:34

Like (0)

Report

Re: Search in PowerApps Form

ok, back, sorting out this new gallery an going to test it out.
Miik 94 on 01 Sep 2023 at 07:51:02

Like (0)

Report

Re: Search in PowerApps Form

Hi, out on site ATM, back in office about 11am. I'll check all previous and let you know. Appreciate your help.
SpongYe 5,580 Super User 2025 Season 1 on 31 Aug 2023 at 21:46:49

Like (0)

Report

Re: Search in PowerApps Form

@Miik

Please let me know if it worked.
If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.
Miik 94 on 31 Aug 2023 at 12:36:03

Like (0)

Report

Re: Search in PowerApps Form

Thanks, I'll try to do another screen with the gallery and let you know how if goes