Unanswered

Combining search, filter on People Picker and drop downs

(0) Share

Report

Posted on by sec4zj

Hello! I am trying to filter a gallery, and I have two drop downs and two text inputs I'm trying to search with. I'm trying to combine the two formulas into one formula for my gallery.

For searching the people picker:
Search(
AddColumns(
'VQMS Requests',
"displayname",
Requestor.DisplayName
),
BusinessReview_RequestorFilter.Text,
"displayname",
"Title"
)

For filtering with the drop downs:
If(
// All filters selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value = "All",
'VQMS Requests',
// Only status selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value <> "All",
Filter('VQMS Requests', 'Status'.Value = BusinessReview_StatusFilter.Selected.Value),
// Only priority selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value = "All",
Filter('VQMS Requests', 'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value),
// Process and Status
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value = "All",
Filter('VQMS Requests', 'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value),
)

My one remaining search text field is just a regular text column, but advice on where to put it in the combined formula would also be much appreciated.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @sec4zj

Try the following and let me know if it works or not:

Filter(
AddColumns(
'VQMS Requests',
"displayname",
Requestor.DisplayName
),
If(
// All filters selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value = "All",
true,
// Only status selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value <> "All",
'Status'.Value = BusinessReview_StatusFilter.Selected.Value,
// Only priority selected
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value = "All",
'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value,
// Process and Status
BusinessReview_ProcessFilter.Selected.Value = "All" And BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value = "All",
'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value
) &&
If(
// Additional search criteria for the text input
IsBlank(SearchText.Text) Or
StartsWith('Request Title', SearchText.Text) Or
StartsWith('AnotherColumnName', SearchText.Text),
true,
false
)
)
sec4zj 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your quick reply! The below runs without an error and handles everything but typing in the Requestor field, which is a People Picker. Do you know why the code I listed above might work but not what's listed below?

Filter(
AddColumns(
'VQMS Requests',
"displayname",
Requestor.DisplayName
),
StartsWith('ID', BusinessReview_RequestIDFilter.Text),
If(
// All filters selected
BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value = "All",
true,
// Only status selected
BusinessReview_PriorityFilter.Selected.Value = "All" And BusinessReview_StatusFilter.Selected.Value <> "All",
'Status'.Value = BusinessReview_StatusFilter.Selected.Value,
// Only priority selected
BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value = "All",
'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value,
// Priority and Status
BusinessReview_PriorityFilter.Selected.Value <> "All" And BusinessReview_StatusFilter.Selected.Value <> "All",
'Priority Decision' = BusinessReview_PriorityFilter.Selected.Value And 'Status'.Value = BusinessReview_StatusFilter.Selected.Value
)
)