SearchBox Query Code Issue.

(0) Share

Report

Posted on by AndyPowerAppNew

519

Hello,

I have built a search box, i think there is an issue with my code, because when searching i need to type in the full name exactly as written to return the results, when I would like to start typing the name and it will return the results, please may you help me achieve this outcome? Here is my code below:

The Name column in the SP is a Single line of text.

Is there a way of not showing anything on screen until the user starting typing in the textbox, would be better if they didnt see a list until started typing.

Thank you

Kind Regards

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
When you use Filter the condition must be true as you are using "'Name (FirstName)'= TextInput1.Text" it must be equal, I suggest using Search or StartsWith, like this:
Search(Visitorentrylist,TextInput1.Text,"Name (FirstName)")
or
Filter(Visitorentrylist,StartsWith('Name (FirstName)',TextInput1.Text))
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp ,
Thank you, i have used the second formula, as below;
however is there a way of not showing the list, which is visbale when the screen loads, just the searchbox, and they type name, then it shows the result?

Thanks
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
yes, you can add another condition to check if the searchbox is empty like this:
Filter(Visitorentrylist,StartsWith('Name (FirstName)',TextInput1.Text) && !IsBlank(TextInput1.Text))
Or set the gallery visible to:
!IsBlank(TextInput1.Text)

Both works, but I prefer the first solution because there are some frames that will display some unexpected items and then they will disapear (in this context visible property is faster than items)
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp ,
That is perfect - Thank you, also is there something where i can put records in alphabetical order automatically in the gallery?
Thanks
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
and yes, you can sort it by any column that you want, like this:
Sort(Filter(Visitorentrylist,StartsWith('Name (FirstName)',TextInput1.Text) && !IsBlank(TextInput1.Text)), 'Name (FirstName)')
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp , Thank you, how can i add sort alphabetical order automatically to this string?
Filter(VisitorEntryList,StartsWith('Name (FirstName)',TextInput1.Text) && !IsBlank(TextInput1.Text),IsBlank(Status.Value))
Kind Regards
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
try this:
Sort( Filter(VisitorEntryList,StartsWith('Name (FirstName)',TextInput1.Text) && !IsBlank(TextInput1.Text),IsBlank(Status.Value)) , 'Name (FirstName)', Ascending)
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp,
Thats great, Thank you - what would i need to apply alphabetical sort to this:
Filter(
StaffWhosIn,
IsBlank(TextInputStaff.Text) ||
StartsWith(
Name.Value,
TextInputStaff.Text
),
IsBlank(Status.Value)
)

Thanks
Verified answer

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Sort function works like this:
Sort( YourCollection/List/Table , Column to be sorted, Ascending/Descending)

Sort( Filter( StaffWhosIn, IsBlank(TextInputStaff.Text) || StartsWith( Name.Value, TextInputStaff.Text ), IsBlank(Status.Value) ), YourColumn, // Replace with the name of your column Ascending )

If it resolve your problem please accept it as solution