Filter Multiple Search

(0) Share

Report

Posted on by oappdev

901

I been searching the whole Forums trying to figure out how to use Filter for multiple search. Using a SharePoint List.

l'm using the following Formulas to search for Patient Name

Filter(COVID19Test, StartsWith('Patient''s Last Name, First Name',TextInput1_1.Text))

Center is a Lookup call "Center Name"

Date of Birth is a "Date and Time"

Hope i explain myself clearly 🙂 and always thank you in advance.👍

Let me know if you need more information.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@oappdev

This is how I would typically accomplish a multiple field search.

Filter(COVID19Test, (IsBlank(TextInput_Center.Text) Or StartsWith(Center,TextInput_Center.Text)) And (IsBlank(TextInput_PatientsName.Text) Or StartsWith(PatientsName,TextInput_PatientsName.Text)) And (IsBlank(TextInput_DateOfBirth.Text) Or StartsWith(DateOfBirth,TextInput_DateOfBirth.Text)) )

Note: I'm not sure about how that search for the DateOfBirth is going to work as a Text field though. Seems like alot of opportunity to mix up the date formatting 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @oappdev

As @mdevaney says, the problem will be the date field. There are too many ways that a User can enter the date in the wrong format. I suggest that you replace the date textbox with a Datepicker control. Then you can use 'Date of birth" = DatePicker1.SelectedDate in the formula he suggests. If I were designing your app, I would use either dropdowns or comboboxes for the other fields as well depending on the number of items in your list.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much! @mdevaney Agree with on DateOfBirth. Will give a try and circle back.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Drrickryp It was a quick request from the company.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@oappdev

It has been my unfortunate experience that users will invariably misspell text entries. The less options you give them, the better.

Was this reply helpful? Yes No