Unanswered

Add multiple search boxes in the datatable to search

(0) Share

Report

Posted on by vikz4

Hi Community

I currently have 1 box in which i am searching in a specifc column from a datatable, however i want to add 1 more box in which i can search the values of one more column...how can i do that? is it possible?

Below is the code i am using:

SortByColumns(
Filter(
'BT Governance Summary_list2',
StartsWith(
'Project Name',
TextInput2.Text
) &&
(
Len(ComboBox1_1.Selected.Result) = 0 ||
'Sub Process'.Value = ComboBox1_1.Selected.Result
) &&
(
Len(ComboBox1.Selected.Result) = 0 ||
Tower.Value = ComboBox1.Selected.Result
) &&
(
Len(ComboBox1_2.Selected.Result) = 0 ||
'Project Status'.Value = ComboBox1_2.Selected.Result
) &&
(
Len(ComboBox1_3.Selected.Result) = 0 ||
'Project Type'.Value = ComboBox1_3.Selected.Result
)
),
"ProjectName",
Ascending
)

Please help me in adding the correct piece of formula at a correct location...

following is a screenshot of the app:

I want to add one more box that says "search by project owner" (project owner is a person type column in sharepoint)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @vikz4 ,

Something like this should do it - also make the Default of TextInput2 "" (empty string)

SortByColumns( Filter( 'BT Governance Summary_list2', ( StartsWith( 'Project Name', TextInput2.Text ) || StartsWith( 'Project Owner', TextInput2.Text ) ) && ( Len(ComboBox1_1.Selected.Result) = 0 || 'Sub Process'.Value = ComboBox1_1.Selected.Result ) && ( Len(ComboBox1.Selected.Result) = 0 || Tower.Value = ComboBox1.Selected.Result ) && ( Len(ComboBox1_2.Selected.Result) = 0 || 'Project Status'.Value = ComboBox1_2.Selected.Result ) && ( Len(ComboBox1_3.Selected.Result) = 0 || 'Project Type'.Value = ComboBox1_3.Selected.Result ) ), "ProjectName", Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
vikz4 17 on at

Like (0)

Report

I tried this but it says "invalid argument type(record). Expecting a text value instead"

Maybe because the 'Project Owner' field is of type 'Person'....is there any other way we can do this?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @vikz4 ,

Try

StartsWith( 'Project Owner'.DisplayName, TextInput2_1.Text )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
vikz4 17 on at

Like (0)

Report

Yes it seems to be working but both the search fields are not working individually... there should be data in both the search boxes in order for it to work....can we not remove the dependency of them on each other?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

@vikz4 ,

As I noted, set their Default to ""

Was this reply helpful? Yes No