Adding a search bar to a gallery error

(0) Share

Report

Posted on by jolebe09

121

Hi all,

I am trying to add a search bar function to a gallery - so as the user can search for a date in the data set and view that entry. However, I am getting some errors when trying to add this function.

I have attached some screenshots to show what I have tried.

The table I am searching in is a SP list.

Please let me know if you require any further information.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @jolebe09,

The Search() function expects the column to be of type Text. Should you want to give the user the possibility to filter via Date, you might want to use a DatePicker control and a Filter() function instead:

Filter( SolihullBS1, MonShiftStart = DatePickerControl.SelectedDate //Rename DatePickerControl to the correct name )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (1)

Report
Copy link

Link copied!

@jolebe09 ,

Search() function is not delegable to SharePoint and using this will raise a delegation warning from the app.
You need to reconsider your scenario and if it suitable to use startswith() function.

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (1)

Report
Copy link

Link copied!

Hey @jolebe09

Instead of Search, you can use a Filter function here.

Filter(SolihullBS1, BS1SearchBox.Text="MONShiftStart")

I hope this helps 🙂

Was this reply helpful? Yes No
jolebe09 121 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM thanks for getting back to me!
I'm afraid I'm not familiar with the date picker function - would this be the TextInput card I have created as the search bar?
Apologies, thank again.
J

Was this reply helpful? Yes No
jolebe09 121 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik thanks so much for your response!

I have tried your solution and I'm afraid I'm unable to search/filter anything. As the gallery is empty - when the search bar is empty and if I try to search an entry in the gallery.

Do you know why this might be? Thank you again!!

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @jolebe09,

A DatePicker is a Power Apps control (just as TextInput is one), which would allow you to filter the Date column based on a date selection (should MONShiftStart be a date column). Filtering via a TextInput is mainly used to filter/search through text fields or choice column values.

In theory, you could create a text value of your date column - but be aware that this is not delegable (& a DatePicker is better UI/UX wise):

Search( AddColumns( SolihullBS1, "MonShiftStartText", Text(MonShiftStart, "dd/mm/yyyy") ) BS1SearchBox.Text, "MonShiftStartText" )

The user can now search based on the date text field (searchtext has to follow the day/month/year format).

I hope this helps!

Was this reply helpful? Yes No
jolebe09 121 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM thank you again!!

I'm really sorry, but it's still flagging a load of errors.
Could this also be that there is a time attached to the date?
Like this

For reference - this is how the list is set up

Thanks again
J

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (2)

Report
Copy link

Link copied!

@jolebe09

Though @LaurensM solution is the most appropriate in your case. But if you want to try the following you can:

If(IsBlank(BS1SearchBox.Text),
SolihullBS1,
Filter(L2, BS1SearchBox.Text in MONShiftStart)

)

or

If(IsBlank(BS1SearchBox.Text),
SolihullBS1,
Search(SolihullBS1,BS1SearchBox.Text,"MONShiftStart")

)

@LaurensM What are your views on this??

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
@jolebe09,

I just noticed a missing comma in my previous code (see red):

Search(
AddColumns(
SolihullBS1,
"MonShiftStartText",
Text(MonShiftStart, "dd/mm/yyyy")
),
BS1SearchBox.Text,
"MonShiftStartText"
)

Since it is a DateTime field, in the case of a DatePicker use:

Filter( SolihullBS1, //Rename DatePickerControl to the correct name MonShiftStart >= DatePickerControl.SelectedDate && MonShiftStart <= (DatePickerControl.SelectedDate + Time(23,59,59)) )

I hope that helps!

Was this reply helpful? Yes No
jolebe09 121 on at

Like (1)

Report
Copy link

Link copied!

@LaurensM thanks so much!! And thank you for your patience!

Was this reply helpful? Yes No