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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No