Answered

Search Gallery by Person Column with Filters Check Boxes for Past due

(0) Share

Report

Posted on by usoneillb

Im trying to add a search text input box to search by "Owner" which is a person column in Sharepoint to the below filter I have already to my gallery so I can search and also have the below filters too that can be chosen.  Any ideas on how to search by "Owner" Display name that is typed into a text box in addition to below ? 
 
 
 If(
    ChkFilter_Ontime.Value,
    Filter('Action Tracker', Overdue = "On-time"),
    ChkFilter_Overdue.Value,
    Filter('Action Tracker', Overdue = "Overdue"),
    ChkFilter_Due_Today.Value,
    Filter('Action Tracker', Overdue = "Due Today"),
    ChkFilter_Complete.Value,
    Filter('Action Tracker','Status'.Value = "Complete"),
    'Action Tracker'
    )
   

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (1)

Report

As Owner is Person type, you need to filter it by DisplayName of the Person

you may try filter like below
Filter(
'Action Tracker',
If(
ChkFilter_Ontime.Value, Overdue = "On-time",
ChkFilter_Overdue.Value, Overdue = "Overdue",
ChkFilter_Due_Today.Value, Overdue = "Due Today",
ChkFilter_Complete.Value, 'Status'.Value = "Complete",
true
) &&
(
IsBlank(txtSearchOwner.Text) ||
StartsWith(Owner.DisplayName, txtSearchOwner.Text)
)
)

or if you want case - insensitive search

Search(
Filter(
'Action Tracker',
If(
ChkFilter_Ontime.Value, Overdue = "On-time",
ChkFilter_Overdue.Value, Overdue = "Overdue",
ChkFilter_Due_Today.Value, Overdue = "Due Today",
ChkFilter_Complete.Value, 'Status'.Value = "Complete",
true
)
),
txtSearchOwner.Text,
"Owner.DisplayName"
)

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

Like (0)

Report
Hi @usoneillb,

Adding some Delegation capacity to this as well
With( { _Due: If( ChkFilter_Ontime.Value, "On-time", ChkFilter_Overdue.Value, "Overdue", ChkFilter_Due_Today.Value, "Due Today", ChkFilter_Complete.Value, "Complete" ) }, With( { _Data: Filter( 'Action Tracker' _Due = Blank() || Overdue = _Due ) }, Search( AddColumns( _Data, OwnerName, Owner.DisplayName ), YourSearchBox.Text, OwnerName ) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
usoneillb 14 on at

Like (0)

Report

Thank you both for your help. This helped me greatly. I ended up going with @SwatiSTW your first suggestion.

This one listed below you suggested worked perfectly.

Filter(
'Action Tracker',
If(
ChkFilter_Ontime.Value, Overdue = "On-time",
ChkFilter_Overdue.Value, Overdue = "Overdue",
ChkFilter_Due_Today.Value, Overdue = "Due Today",
ChkFilter_Complete.Value, 'Status'.Value = "Complete",
true
) &&
(
IsBlank(txtSearchOwner.Text) ||
StartsWith(Owner.DisplayName, txtSearchOwner.Text)
)
)

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

Like (0)

Report

Hi @usoneillb,

The structure I used was hopefully to give you (almost) full Delegation functionality while still providing a full Search function (anywhere in the field) rather than StartsWith

Was this reply helpful? Yes No